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.
I have a table, example below that I'm trying to create a sum measure that will return The Cumulative Rep Revenue by Month. The should return column is the expected result from the measure based on the Rep and Month in the Example.
I tried using calculate sum but can't get it to work with the filters.
Can someone help with the DAX measure.
Rep | Product | Month | Revenue | Should Return |
Bob | A | 2019-01 | 1000 | 3000 |
Bob | B | 2019-01 | 2000 | 3000 |
Bill | B | 2019-01 | 500 | 1200 |
Bill | C | 2019-01 | 700 | 1200 |
Bob | A | 2019-02 | 200 | 200 |
Bill | B | 2019-02 | 1200 | 1200 |
Bob | A | 2019-03 | 500 | 2100 |
Bob | B | 2019-03 | 600 | 2100 |
Bob | C | 2019-03 | 1000 | 2100 |
Solved! Go to Solution.
A measure
Measure 2 = CALCULATE(SUM(Table4[Revenue]), ALLEXCEPT( Table4, Table4[Rep], Table4[Month]))
A measure
Measure 2 = CALCULATE(SUM(Table4[Revenue]), ALLEXCEPT( Table4, Table4[Rep], Table4[Month]))
Hi @HotChilli ,
What if the columns in the visual are from different data tables, not the same table source in the dataset?
Thanks,
Measures evaluate according to context so, depending on these other fields, you may get different results. You might try a calculated column (DAX is not the same but it's close)
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 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |