Forum Discussion

Fraze's avatar
Fraze
Icon for Helper I rankHelper I
5 years ago
Solved

Subtotal Needs to Calculates Differently than Row Level

Hello,   I have a matrix using a measure with the DAX expression 'Expense / Sales'.   So each row represents a % of total sales. see below:     Currently my subtotal for the 3 year avera...
Need Help
Show and Tell
Tips and Tricks
  • v-xulin-mstf's avatar
    v-xulin-mstf
    5 years ago

    Hi Fraze

     

    You can use HASONEVALUE to modify the calculation logic of  subtotal.

    Try measure as:

    IF(
    HASONEVALUE('Table'[Column]),
    measure,
    new measure    //calculation logic of '69.75%'
)

     

    Best Regards,

    Link 

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

Fraze's avatar
Fraze
Icon for Helper I rankHelper I
5 years ago

Thanks for the information.

 

Unfortunatly, my date does have some filters in the background. In addition to what you already mentioned, Any further insight on how to best deal with that. 

 

Thanks

jonoling's avatar
jonoling
Frequent Visitor
5 years ago

Hi Fraze,

 

Just following up to see if this solved your issue?