Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have this formula:
Solved! Go to Solution.
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.
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! |
@lkalawski , hi, I've tried with all but if I select different region in the visualization it changes the same
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! |
@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
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! |
@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
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.
Thanks, it works!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |