DAX Formula - Follow Filter Context Except...

Anything related to PowerPivot and DAX Formuale
Jonny1010101010
Posts: 11
Joined: Wed Oct 17, 2018 5:23 am

DAX Formula - Follow Filter Context Except...

Postby Jonny1010101010 » Wed Oct 17, 2018 6:47 am

Hi

I dont have an example workbook Im afraid, but for example:

Month - Week - Product - Customer

Do you know what the best DAX formula would be to achieve

Month/Week/Product - as per the pivot's filter context
Customer - All (ignore any other filters on Customer)

Thanks, Jonny

RamanaV
Posts: 29
Joined: Thu Oct 19, 2017 12:57 pm

Re: DAX Formula - Follow Filter Context Except...

Postby RamanaV » Wed Oct 17, 2018 10:27 am

Hi,

What is the Measure you have? Assuming that it is [Total Sales], you can try the following:

Total Sales for all Customers = CALCULATE([Total Sales], ALL(Customers))

Hope this solves your problem.

Ramana

Jonny1010101010
Posts: 11
Joined: Wed Oct 17, 2018 5:23 am

Re: DAX Formula - Follow Filter Context Except...

Postby Jonny1010101010 » Thu Oct 18, 2018 5:06 am

Works perfectly, thank you :)

Jonny


Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 4 guests