Comparing Decimal numbers in DAX

[abhiram342]

Hi All,

We want to create measure by comparing  decimal numbers . I have created below measure but numbers are not matching with Source

EX:

[Usage] = Sum(Usage) ( note: here Usage is stored as decimal)

Product Count (Usage = 0):= CALCULATE(DISTINCTCOUNT('Table'[Product]),FILTER(VALUES('Table'[Product]),[Usage]=0))

Product Count (Usage < 100):= CALCULATE(DISTINCTCOUNT('Table'[Product]),FILTER(VALUES('Table'[Product]),[Usage]<100))

Thanks,

Abhiram

[amitchandak]

@abhiram342 , Try like

Product Count (Usage = 0):= CALCULATE(countx(FILTER(VALUES('Table'[Product]),[Usage]=0),[Product]))

Product Count (Usage < 100):= CALCULATE(countx(FILTER(VALUES('Table'[Product]),[Usage]<100),[Product]))