Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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)