Forum Discussion

socalmark's avatar
socalmark
New Member
5 years ago

DAX Matrix Help

Hi all,

wanted to see if it was possible to change the "count of _______" in the values section of the Power BI matrix to showing a "X" if there is a value and blank if there is no value. Thanks for the help!

1 Reply

  • mahoneypat's avatar
    mahoneypat
    Microsoft Employee
    5 years ago

    Yes.  Make a measure like this, changing Table and Column to match actual names in your model.

     

    CountMeasure = var mycount = COUNT(Table[Column1])

    Return IF(ISBLANK(mycount), BLANK(), "X")

     

    Regards,

    Pat