Forum Discussion

Knechtion's avatar
Knechtion
New Member
5 years ago

KPI (blank) when a single value is blank

I am using a KPI visual for multiple individual monthly metrics over the course of a year. There are 6 metrics but not all of them can occur every month. I have logic to handle if they select a date ...
Need Help
v-robertq-msft's avatar
v-robertq-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi, Knechtion 

According to your description and sample pictures, I can clearly understand your problem, I have a little trick that can help to solve this problem in the Power BI, you can take a look at my steps and find if it’s helpful:

This is my test data:

 

  1. I created a new table like this:
ID = SUMMARIZE('Table',[ID])
  1. Then I related these two tables:

 

  1. I created a measure like this:
Measure =

IF(SUM('Table'[Value])=BLANK(),0,SUM('Table'[Value]))
  1. I went to the original matrix and reaplce the fields in the matrix like this:

 

And you can get what you want.

You can download my test pbix file below

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.