Forum Discussion

Bizo's avatar
Bizo
Frequent Visitor
3 years ago
Solved

Have Count Card show zero instead of (blank)

Hi,   I have multiple count cards on my dashboard that are filtering for 'New' items.  I am currently using conditional formatting that changes the color to the background if there are no values bu...
Need Help
  • barritown's avatar
    barritown
    3 years ago

    I guess something like:

    Measure = COALESCE ( COUNT ( 'Your Table'[Title] ), 0 )

     

    You should put it to your visual instead of 'Count of Title'.

Bizo's avatar
Bizo
Frequent Visitor
3 years ago

That worked I think, thanks!

barritown's avatar
barritown
Icon for Solution Sage rankSolution Sage
3 years ago

Great. 

 

BTW, there is also another option to achieve this: 

Measure = COUNT ( 'Your Table'[Title] ) + 0