cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
marvicf
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
Floriankx
Solution Sage
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.

View solution in original post

4 REPLIES 4
Floriankx
Solution Sage
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.

View solution in original post

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

Hi,

Thanks for your reply.

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

Thanks.

Stachu
Community Champion
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



Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

Proud to be a Super User!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.