Using condition in distinct count and dividing it

[Anonymous]

I have a requirement that i need to divide Distinct count of ID's whose salary is <= 25000 divided by distinct count of Id's.

value=Distinct count of ID's whose salary is <= 25000/ distinct count of Id's.

value = calculate(distinctcount(rawdata[id]),rawdata[salary] <= 25000 / distinctcount(rawdata[id])) .

However, this is giving me error.

Let me know any suggestion to achive this in single formula.

Thanks!!

[az38 · Accepted solution]

Hi @Anonymous 

try

value = 
DIVIDE(
calculate(distinctcount(rawdata[id]), rawdata[salary] <= 25000) ,
calculate(distinctcount(rawdata[id]), ALL(rawdata))
) 

[az38 · Accepted solution]

Hi @Anonymous 

try

value = 
DIVIDE(
calculate(distinctcount(rawdata[id]), rawdata[salary] <= 25000) ,
calculate(distinctcount(rawdata[id]), ALL(rawdata))
) 

[Anonymous · Accepted solution]

hi @az38 ,Thanks,

It is rounding the values like 18/21 = 0.85 but it displays 1. How can i display exact value??

Thanks!!

[az38]

@Anonymous 

pick your measure in the right Fields Pane then go to Measure tools ribbon and set Decimal place parameters to 2