If over 100% then 100% in DAX

[diogobraga2]

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

[amitchandak · Accepted 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