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.
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
@Anonymous , Try like
Sumx(values(Table[Category]) ,calculate( Switch(True() ,
Max(Table[Category]) = "Cat1" , [Measure1] ,
Max(Table[Category]) = "Cat2" , [Measure2]
// Add others
) )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |