0

I have the below matrix in the paginated report, if a cell is blank I want to fill the value from the column "All". Any idea?

Image

From the above example for the first row, all blank cells should be filled with a value from "All" column (49).

Prasoothan Kannanbeth
  • 1
  • 2
  • Does [this](https://stackoverflow.com/questions/57855342/power-bi-if-blank-then-put-value) answer your question? The issue is similar, but read both the question and the answer. – FiddlingAway Jan 22 '23 at 14:01
  • If the "all" column a total column or does it appear in your dataset as "all"? If you can share some sample data from your dataset that would be useful. – Alan Schofield Jan 23 '23 at 11:23

0 Answers0