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.

Stachu's avatar
Stachu
Community Champion
8 years ago

rather than creating calculated column I'd recommend creating calculated measure
Ratio = DIVIDE(SUM('Table1'[ColumnA]),SUM('Table2'[ColumnA]))
this syntax doesn't make sense as calculated column, but will give correct ratio on aggregated level