KPI Visuals and (Blank) - Issue with making (Blank) a 0

[MarkMellink]

The measure that is being displayed in the KPI is a monthly average of several of the DISTINCTCOUNT measures displayed on the right. If it can't find any occurrences it returns (Blank), resulting in the KPI picture at the top.

I know this is a common problem and that people solve it by either doing the following:

[Measure] + 0

or

IF(ISBLANK([Measure]),0,[Measure])

I've tried both of these solutions. This works for 0 values, but for some reason, they change my measure to 0 always, even if there are values to be counted.

See this example below:

Before change:

After change:

This is the measure in question, the change is highlighted in bold at the end of the code:

Active Internal Users = CALCULATE(DISTINCTCOUNT(PlatformEvents[UserId]), PlatformEvents[CountEvents] > 0) + 0

 The average in the KPI is calculated as follows:

Average Active Internal Users Last Month = ([Active Internal Users] +
     CALCULATE([Active Internal Users],DATEADD(TimeDimension[Date],-7,,DAY)) +
     CALCULATE([Active Internal Users],DATEADD(TimeDimension[Date],-14,,DAY)) +
     CALCULATE([Active Internal Users],DATEADD(TimeDimension[Date],-21,,DAY)))/4

Note the extra commas (,,) after numbers in the above DAX code. For some reason whenever I add numbers I need to add an extra comma otherwise it doesn't see it as a proper comma for the next argument. This might have something to do with my problem?

I was wondering if anyone ever had this problem before? It's quite frustrating and could easily be solved if I had the option in this idea thread.

Any help would be appreciated!

[Anonymous]

Hi.

It is because, in addition to not wanting empty, the KPI visual works ONLY on the CUMULATED measures! 

I spent the whole day to figure it out.

Hope it helps.

[MarkMellink]

Great thanks, very interested to find out what the cause of this is!

[MarkMellink]

Yes here is some sample data with the (Blank) occurrence (the app example in my OP):

https://ufile.io/5lz3u

Here is sample data without the (Blank) occurrences (the user example in my OP), but that can be used to test 0 problem once you add +0 to the formula:

https://ufile.io/41nve

They're .csv files. If you would prefer something else let me know!

[Greg_Deckler]

OK, I have the files, CSV's are good. I'll take a look at it.

[Greg_Deckler]

Can you share some made-up or sample data? I'd like to experiment with this.