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.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

By using HASONEVALUE function, the total is working properly but row level calculation is not working it shows blank but it shows value -

 

Code - 

 

IF(

     HASONEVALUE ('jci fact_VoucherGL'[VoucherDate])

         ,CALCULATE(

                         LEFT(

                                 max('jci fact_VoucherGL'[VoucherDate])

                         ,10)

        ,FILTER('jci fact_VoucherGL',[UR_NextYear]=0)

        ,FILTER('jci fact_VoucherGL',[UR_NextYear]=BLANK())

   ),BLANK())