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.

  • 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())