Forum Discussion

smmcqueen's avatar
smmcqueen
Frequent Visitor
1 year ago
Solved

Matric Visual Total Not Accurate

As you can see in the below visual, my matrix displays a total percent (thrid column at the bottom - 43.90%) that does not align with the percents in each row. Is there a way to hide the total percent without hiding the grand total of headcount (column 2 - 3201)?

 

 

Need Help
  • Kedar_Pande's avatar
    Kedar_Pande
    1 year ago

    Create a new measure that checks if the current row is a total and returns a blank value:

    Display Percentage = 
    IF(
    ISINSCOPE(YourTable[Year]),
    [YourPercentageMeasure],
    BLANK()
    )

    Use this new measure in your Matrix instead of the original percentage measure.

     

    If this helped, a Kudos 👍 or Solution mark would be great! 🎉
    Cheers,
    Kedar
    Connect on LinkedIn

3 Replies

  • _AAndrade's avatar
    _AAndrade
    Resident Rockstar
    1 year ago

    Hi smmcqueen,

    In your measure put one IF statement like this:

    IF(
    ISINSCOPE('YourTable'[YourColumn]), 
    [your measure]
    BLANK() -- Return blank at the total
)
  • SamWiseOwl's avatar
    SamWiseOwl
    Super User
    1 year ago

    Hi smmcqueen 

    You can create a measure:
    Hide Total specific column =
    If(
     isFiltered(table[Year]), [Your calculation], Blank())

    Is filtered returns TRUE on the row but FALSE on the total.

    You could also do HasOneValue(table[Year]) as the total has many years and the row has one.

  • Kedar_Pande's avatar
    Kedar_Pande
    Super User
    1 year ago

    Create a new measure that checks if the current row is a total and returns a blank value:

    Display Percentage = 
    IF(
    ISINSCOPE(YourTable[Year]),
    [YourPercentageMeasure],
    BLANK()
    )

    Use this new measure in your Matrix instead of the original percentage measure.

     

    If this helped, a Kudos 👍 or Solution mark would be great! 🎉
    Cheers,
    Kedar
    Connect on LinkedIn