Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Display ZERO if No Data found

Hi PBI Guris   I have a very simple chart below and which is the number of “Critical” alerts for a particular AWS account.     As you can see in the beginning  – it stated at 24 x Critical...
Need Help
  • az38's avatar
    az38
    2 years ago

    Hi Anonymous 

     

    I suggest, you use an implict measure, that is always a bad practice

    Good is to create an explicit and +0 and the end, like

    Qty measure = CALCULATE(SUM('Table'[Qty])) + 0

    Use this measure as a value

az38's avatar
az38
Icon for Community Champion rankCommunity Champion
2 years ago

Hi Anonymous 

 

I suggest, you use an implict measure, that is always a bad practice

Good is to create an explicit and +0 and the end, like

Qty measure = CALCULATE(SUM('Table'[Qty])) + 0

Use this measure as a value