Forum Discussion

Majidbhatti's avatar
Majidbhatti
Icon for Advocate IV rankAdvocate IV
5 years ago
Solved

HASONEVALUE adding BLANK row

I am trying to fix TOTALS of a Matrix but ending up with adding a BLANK row as shown in the image below   My measure is as below, I have values to replace 2, 3, 4, & 5 but keeping it simple h...
Need Help
  • Majidbhatti's avatar
    Majidbhatti
    5 years ago

    Issue Fix. There was problem in relations between tables

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

In the Filter panel, highlight that visual and uncheck the Blank box for the Revenue column.  You could also do it with DAX with and AND or a nested IF, but that is easier.

Regards,

Pat