Percentage measure from other measure

[CollabTechie]

Hi Community,

I have a distinct measure to pull back unique users but I need to create another measure that uses this value and provides me with the distinct value as a percentage of 25,000. It will always be 25,000

Current measure that works fine

UniqueFlowUsers = COUNTROWS(DISTINCT(Flows[Owner]))

Any help would be much appreciated

Thanks,
CT 

[edhans · Accepted solution]

New Measure = DIVIDE([UniqueFlowUsers],25000,0)

[CollabTechie]

Hi @edhans , that worked. Thank you!

[edhans]

Great. The final ,0 really isn't necessary in this case. It is the alternate answer if the denominator is 0 so you don't get an error, but in your particular case, the denominator is hardcoded at 25,000, so it will never happen in this measure, but it is good practice to get in the habbit of supplying the alternate answer for other measures.