Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Using condition in distinct count and dividing it

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...
Tips and Tricks
  • az38's avatar
    az38
    6 years ago

    Hi Anonymous 

    try

    value = 
DIVIDE(
calculate(distinctcount(rawdata[id]), rawdata[salary] <= 25000) ,
calculate(distinctcount(rawdata[id]), ALL(rawdata))
)
  • Anonymous's avatar
    Anonymous
    6 years ago

    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's avatar
az38
Community Champion
6 years ago

Hi Anonymous 

try

value = 
DIVIDE(
calculate(distinctcount(rawdata[id]), rawdata[salary] <= 25000) ,
calculate(distinctcount(rawdata[id]), ALL(rawdata))
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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's avatar
      az38
      Community Champion
      6 years ago

      Anonymous 

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