Forum Discussion

tim_001's avatar
tim_001
Helper I
2 years ago
Solved

Power BI - Matrix Visual - Issue with "Show items with no data" in the same Row

Hi, I am experiencing issues with the Show Items with No Data.    I have a Product Name and underlying Product Numbers in a Matrix Visual under Rows. Under Values I have how many we have sold. For ...
Need Help
  • Joe_Barry's avatar
    Joe_Barry
    2 years ago

    Hi tim_001 

    Maybe redo your Sales measure

    Sales =
IF(
   SUM(Sales[Amount]) = BLANK(), 0,
   SUM(Sales[Amount])
)

     

    Joe

     

    Did I answer your question? Mark my post as a solution!

Joe_Barry's avatar
Joe_Barry
Solution Sage
2 years ago

Hi tim_001 

Maybe redo your Sales measure

Sales =
IF(
   SUM(Sales[Amount]) = BLANK(), 0,
   SUM(Sales[Amount])
)

 

Joe

 

Did I answer your question? Mark my post as a solution!