Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Priya2007
Frequent Visitor

Groupby measure and sum

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.
 
1 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.

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@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])

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors