topic Re: Calculate SUM from a calculated measure in DAX Commands and Tips

Calculate SUM from a calculated measure

Anonymous — Tue, 27 Sep 2022 13:22:42 GMT

Hi,

I am using the measure below to get output as 0 & 1 and now from this output i need to calculate the sum of 0's & 1's.
from a measure we cant create a SUM right.
What is the alternative to get sum of 0 & 1 from the Below measure, Any suggestions please?

measure =

VAR _dCount =

COUNTROWS (

FILTER (

ALL ( 'DB 15092022_1' ),

'DB 15092022_1'[STO Number] = SELECTEDVALUE ( 'DB 15092022_1'[STO Number] )

&& 'DB 15092022_1'[Index] <= SELECTEDVALUE ( 'DB 15092022_1'[Index] )

)

RETURN

IF ( _dCount > 1, 0, 1 )

Thanks

Re: Calculate SUM from a calculated measure

Greg_Deckler — Tue, 27 Sep 2022 13:34:47 GMT

Anonymous This looks like a measure aggregation problem. See my blog article about that here: https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149

The pattern is:
MinScoreMeasure = MINX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
MaxScoreMeasure = MAXX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
AvgScoreMeasure = AVERAGEX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
etc.

Re: Calculate SUM from a calculated measure

Anonymous — Tue, 27 Sep 2022 14:31:12 GMT

Hi Greg

Thanks for the quick response.
Here i need to do SUM of the 0's & 1's. Grouping is not required
any help please?

Re: Calculate SUM from a calculated measure

Anonymous — Wed, 28 Sep 2022 09:32:06 GMT

I am using the measure below to get output as 0 & 1 and now from this output i need to calculate the sum of 0's & 1's.
from a measure we cant create a SUM right.
What is the alternative to get sum of 0 & 1 from the Below measure, Any suggestions please?

measure =

VAR _dCount =

COUNTROWS (

FILTER (

ALL ( 'DB 15092022_1' ),

'DB 15092022_1'[STO Number] = SELECTEDVALUE ( 'DB 15092022_1'[STO Number] )

&& 'DB 15092022_1'[Index] <= SELECTEDVALUE ( 'DB 15092022_1'[Index] )

)

RETURN

IF ( _dCount > 1, 0, 1 )

Thanks