Forum Discussion

marvicf's avatar
marvicf
Frequent Visitor
8 years ago
Solved

hide measure total

Dear All, I have a measure dividing two columns by each other - DIVIDE('Table1'[ColumnA],'Table2'[ColumnA]) Is there a way to hide the total for this measure. The total is not correct. Thanks. R...
Need Help
  • Floriankx's avatar
    Floriankx
    8 years ago

    Hello,

     

    you can use:

     

    MeasureToDisplay=IF(HASONVALUE([ColumnOfTotal],[Measure],BLANK())

     

    ColumnsOfTotal is the Column you want to show the single value but not the Total for.

     

    Best regards.

Floriankx's avatar
Floriankx
Solution Sage
8 years ago

Hello,

 

you can use:

 

MeasureToDisplay=IF(HASONVALUE([ColumnOfTotal],[Measure],BLANK())

 

ColumnsOfTotal is the Column you want to show the single value but not the Total for.

 

Best regards.

marvicf's avatar
marvicf
Frequent Visitor
8 years ago

Hi,

Thanks for your reply.

The column has more than one value. I just don't want it's total to show.

Thanks.