Display ZERO if No Data found

[Anonymous]

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 Alerts found. In December 2023 it was down to 2x hits.

In late December 2023 I was told they are all clear and when I did a data refresh I saw no data.

And well that’s because I expected.    I would like to however to show a value of ZERO and I was wondering how best you could do this.

If I mimic this in XLS  its currently showing as below where there are no hits for "Crtical"

Ideal situation is as follows:

I added the data in yellow to my source just so I could see my Goal. (Fig 2)

Maybe its my brain and was think of palying with the data source but I would rather do  this in PBI. So every month there will be a scan but to find no values with the "Critcal" label is our aim; its just how to plot this?

Comments welcome

Fug 2

Thanks

Jimmy

[Anonymous]

@az38 

Indeed I re-thought what I was doing and I have my result

I just  used the following with some filters

Count_Critical = CALCULATE ( COUNTROWS ( DOME9), DOME9[Severity] = "Critical" ) + 0

[az38 · Accepted solution]

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