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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

Can a switch measure show up added up value in Group Total

Suppose I have five calculations for five categories (shown in row) and handled using switch or if. Will it be possible to show the added up value as Total? Total takes the calculation I set as default not falling in to any of the categories. Will it be possible to take the total as the sum total of five category special calculations

1 REPLY 1
amitchandak
Super User
Super User

@Anonymous  , Try like

 

Sumx(values(Table[Category]) ,calculate( Switch(True() ,

Max(Table[Category]) = "Cat1" , [Measure1] ,

Max(Table[Category]) = "Cat2" , [Measure2]

// Add others

)  )

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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