Forum Discussion

ys034's avatar
ys034
Icon for Helper I rankHelper I
4 years ago
Solved

Calculation should not change during specific filter selection

Hello community I am learning DAX new recently   I have a question about ignoring a calculation based on the filter criteria As you can see on the picture the market shares are calculated correctl...
Need Help DAX measure
Tips and Tricks
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    How about something simpler?

    CALCULATE (
    SUM ( 'DataTable'[Sales] ),
    ALL ( 'DataTable'[Brand] )
)
v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
4 years ago

Hi ys034 

 

Have you tried Alexis's formula for Grand Total? It should work I think. 

 

Best Regards,
Community Support Team _ Jing