cancel
Showing results for
Did you mean:
Frequent Visitor

## 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

1 ACCEPTED SOLUTION
Solution Sage

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 4
Solution Sage

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.

Helper I

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

Frequent Visitor

Hi,

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

Thanks.

Community Champion

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

Thank you for the kudos 🙂

Proud to be a Super User!

Announcements

#### Launching new user group features

Learn how to create your own user groups today!