dax formula that ignores some column selection

[Giada_Togliatti]

Hi,

I have this formula:

CALCULATE( SUM(Orders[Sales]), FILTER( Orders, MONTH(Orders[Date]) = [mese corrente] ) )

I need to put inside the formula something that tell me that I must ignore selection of the field region.

How can I insert inside the formula?

Thank you

[lkalawski]

Hi @Giada_Togliatti 

I don't know details, but you can add ALL function to the formula:

CALCULATE( SUM(Orders[Sales]), FILTER( Orders, MONTH(Orders[Date]) = [mese corrente] ), ALL(Region) )

 By using it you will ignore any Region filters.

Proud to be a Super User. If I helped, please accept the solution and give kudos!  Linkedin

[Giada_Togliatti]

@lkalawski , hi, I've tried with all but if I select different region in the visualization it changes the same

[lkalawski]

@Giada_Togliatti 

Can you share more information and share .pbix file or sample data? It will help to find a solution for your problem.

Proud to be a Super User. If I helped, please accept the solution and give kudos!  Linkedin

[Giada_Togliatti]

@lkalawski I don't see the option for sharing the pbix, what I need is a measure that doesn't change based on another field in a filter slicer, I used edit interation and it works but I would like to know if there is a way to do in dax too, thank you

[lkalawski]

@Giada_Togliatti ,

Please add to Onedrive or some another storage and share the link here. 

Function All allows you to remove the filter and get all the data from the table or the column, so I need to see your file and structure to check it. 

Proud to be a Super User. If I helped, please accept the solution and give kudos!  Linkedin

[Giada_Togliatti]

@lkalawski , this is the link of pbix file

https://drive.google.com/file/d/1kaX1PWMby_744KrVLAQxSREKI9oEprvv/view?usp=sharing

Now it works because I edit interation and deactivate the interation between slicer and the second card, but I would like to do with dax

[v-jingzhang · Accepted solution]

@Giada_Togliatti 

Please try below measure. This should work.

sales per mese corrente che ignora regione 2 = 
VAR mese = [mese corrente]
RETURN
CALCULATE( SUM(Orders[Sales]), ALL(Orders[Region]), MONTH(Orders[Date]) = mese )

Regards,
Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.

[Giada_Togliatti]

Thanks, it works!