Groupby measure and sum

[Priya2007]

Hi, 

I have one question about aggregation in Power BI:

My Measure = 

(If([SAI]> [SAI liM]*.7 || [SAF]>[SAFLimit]*.7,1,0))

I want to group by this measure by ID and then sum the total (1 or 0)

Let ke know if it is possible.

[amitchandak]

@Priya2007 , Try a measure like

sumx(values(Table[id]),If([SAI]> [SAI liM]*.7 || [SAF]>[SAFLimit]*.7,1,0))

or

sumx(summarize(Table[id],"_1",If([SAI]> [SAI liM]*.7 || [SAF]>[SAFLimit]*.7,1,0)),[_1])

[Priya2007 · Accepted solution]

Hi Amit,

Thanks, it really works well.

Just one more thing I am getting the table correct , is there a way to get the total at the bottom.