hide measure total

[marvicf]

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

[Floriankx · Accepted solution]

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]

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

[marvicf]

Hi,

Thanks for your reply.

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

Thanks.

[Stachu]

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