Forum Discussion

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 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!!

Tips and Tricks

Hi Anonymous

try

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

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!!

3 Replies

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
  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
    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

Related content