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.

Regards

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.

4 Replies

  • 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

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