Forum Discussion

ppgandhi11's avatar
ppgandhi11
Icon for Helper V rankHelper V
8 years ago
Solved

how to display 0 values?

Hi,   I have a measure as below:   TotalDenied = CALCULATE(count(Query1[IsWithinBM]), Query1[IsWithinBM] = "N")   Whenever the value of TotalDenied > 0, it displays fine, but when the value is ...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi

    A simple solution : Add +0 to your formula.

     

    CALCULATE(count(Query1[IsWithinBM]), Query1[IsWithinBM] = "N") + 0

     

     

    P.S: I got this idea few days back from a old post , dont remember exactly but i think it was Sean who posted this idea.

     

    Thanks
    Raj

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi

A simple solution : Add +0 to your formula.

 

CALCULATE(count(Query1[IsWithinBM]), Query1[IsWithinBM] = "N") + 0

 

 

P.S: I got this idea few days back from a old post , dont remember exactly but i think it was Sean who posted this idea.

 

Thanks
Raj