getting grand total zero when using measure and doing calculations.

[amty63]

I am using below formula in the table:

Column = if([measure]<5,DISTINCTCOUNT('FACT'[EMP_ID]),0)

when I am going for table visual, it returns 0.

 Attached snapshot

[v-diye-msft]

Hi  @amty63 

If my above post helps, could you please consider Accept it as the solution to help the other members find it more quickly. thanks!

[v-diye-msft · Accepted solution]

Hi @amty63 

Please use the measure instead:

Measure = IF(MAX([columnvalue])<5,DISTINCTCOUNT('FACT'[EMP_ID]),0)

[amty63]

We are getting an error while using MAX function. 

The MAX function only accepts a column reference as the argument number 1. I am using measure  and need to see the total for measures.

[Anonymous]

@amty63 Please try below measure

measure = CALCULATE(DISTINCTCOUNT('Table'[Country]),'Table'[columnvalue]<5)

Just in case you wan to display zero for other values

Measure = 
VAR _count = CALCULATE(DISTINCTCOUNT('Table'[Country]),'Table'[columnvalue]<5)
RETURN IF(ISBLANK(_count),0,_count)