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.
I have the following measure calculating the percent of total:
Measure =
SUM ( 'Table'[Target] ) / SUM ( 'Table'[Total Students] )
Now, I am applying a conditional formatting that requires inputs from 0-100%, some of the results from the calculation above returns values over 100%. How can I adjust the measure calculation to address this?
I was able to achieve this in other tools using something like shown below. How is this done with DAX?
If
SUM ( 'Table'[Target] ) / SUM ( 'Table'[Total Students] )>1 then 1
else SUM ( 'Table'[Target] ) / SUM ( 'Table'[Total Students] )
end
Solved! Go to Solution.
Try
If
(SUM ( 'Table'[Target] ) / SUM ( 'Table'[Total Students] )>1 , 1
, SUM ( 'Table'[Target] ) / SUM ( 'Table'[Total Students] )
)
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
Try
If
(SUM ( 'Table'[Target] ) / SUM ( 'Table'[Total Students] )>1 , 1
, SUM ( 'Table'[Target] ) / SUM ( 'Table'[Total Students] )
)
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
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 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |