I have a measure : "rupture" which is calculated (substraction) based on two other measures "Stock Week " and stock Week-1.
I have good results when i'm in a weekly bucket, but when i'm in total, it gives me the result based on the total of "Stock Week " and "stock Week-1".
I would like to sum the "rupture " of the weekly buckets when i'm in All(week).
Thanks in advance.
Go to Solution.
If you add some specify filter in measure, it will return the wrong result at total row. In my opinion, you can add a condition to filter the total row and add the specify calculation on it.
Condition Calculate =
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!
Check out what's new in the Power BI Community!