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.
Hello,
I have 2 measures:
Measure1 = CALCULATE([Measure2],ALL(Table1),Table4[Column1]>5)
Measure3 = CALCULATE(MAXX(Table2,RELATED(Table3[Column2])),ALL(Table4))
Hi @PshemekFLK
There is an issue with the structure of your Measure3; you added two expressions, and why did you add ALL(Table4)?
How to Get Your Question Answered Quickly
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos
Hi @VahidDM
Sorry, I put the measure incorrectly initially. Now it's correct in the initial post. Measure 3 is also a CALCULATE
I need ALL in Measure 3 because it should ignore the filters on Table4.
I'm starting to think that I'm missing KEEPFILTERS somewhere since introducing SUMX in the weighted average measure totally ignores the filters added in Measure 1 and Measure 3. Am I on the right track?
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 |
---|---|
47 | |
24 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |