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.
Still struggling with percentage calculations
I have the following in a table
In SLA 30,596
Over 4 Hours 355
Over 6 Hours 556
Over 12 hours 12
Total 31,519
I want to add a gauge to show the percentage of the out of SLAs (Over 4 Hours, Over 6 Hours, Over 12 hours)
I imagine I use an ALLEXCEPT but Im really struggling to put the DAX together. Any help would be appreciated
Solved! Go to Solution.
Hi @DebbieE ,
Please check the following steps as below.
1. Create a measure to calculate the sum of all other rows except the current row, which act as the denominator.
Measure = var a = MAX(Table1[Column1]) return CALCULATE(SUM(Table1[Column2]),FILTER(ALL(Table1),Table1[Column1]<>a))
2. Then calculate the share of each row contributed:
Measure 2 = DIVIDE(SUM(Table1[Column2]),[Measure],0)
Hi @DebbieE ,
Please check the following steps as below.
1. Create a measure to calculate the sum of all other rows except the current row, which act as the denominator.
Measure = var a = MAX(Table1[Column1]) return CALCULATE(SUM(Table1[Column2]),FILTER(ALL(Table1),Table1[Column1]<>a))
2. Then calculate the share of each row contributed:
Measure 2 = DIVIDE(SUM(Table1[Column2]),[Measure],0)
Thank you so much
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 |
---|---|
117 | |
104 | |
77 | |
73 | |
50 |
User | Count |
---|---|
145 | |
109 | |
108 | |
90 | |
64 |