powerpivot,dax,powerview,calculated-measure

If you are using pivot report, then you can use filter option to achieve this.

ssas,mdx,olap-cube,calculated-measure

I have very stupid solution, but it works! The main idea is to send a key of necessary minute-member to hour-level. Create additional empty measures to store keys of max minute value: CREATE MEMBER CURRENTCUBE.[Measures].[Measure A Key Minutes] AS null, VISIBLE = 0; CREATE MEMBER CURRENTCUBE.[Measures].[Measure A Key Hours] AS...

calculated-columns,decimalformat,rounding-error,calculated,calculated-measure

The problem you are having is because SQL is doing integer division, which will only return whole numbers. To get a decimal return value you must have at least one value as a decimal. Try this: (CAST([N] as decimal(12,6))/[D]) * 1000 Adjust decimal(12,6) based on the precision you are expecting....