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.
Good afternoon!
I'm having trouble getting a DAX measure that allows me to do the following:
I would like to have a measure that added the sales of 3 different years and I could keep it in a column of my matrix without the YEARS filter changing the values.
However, I would like the MES filter to affect the measure.
Can you think of any way?
Thanks in advance,
Victor
Please always provide more context with peoblem examples and expected output with screenshots.
From what I understand. You need to use the below.
Calc = CALCULATE(SUM(table[sales]), ALLEXCEPT(Table,Table[Years]))
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
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 |
---|---|
110 | |
94 | |
80 | |
67 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |