Forum Discussion
Matrix Grand Total Changing As Rows Are Added/Removed
Wondering if anyone has come across an issue like this -
I have a matrix visual with a field parameter as the row so users can add or remove dimensions similar to a pivot table. The dashboard contains sales data and is used to compare sales in one period to another.
The data model looks like the image below. Basically a fact table connected to 2 date dimensions, one indirectly, and several other dimensions.
The baseline period sales is normalized to the comparison period using sales per day with the measure below (# of days are variables):
BaselineSales = DIVIDE(CALCULATE(SUM(Fact_Sales[Sales]), ALL(Dim_Date01), USERELATIONSHIP(Fact_Sales[SalesDate], Dim_Date02[Date])), _BaselineDays) * _ComparisonDays
The problem I'm having is that when dimensions are added or removed to the row of the matrix, the baseline sales values are changing. I'm pretty sure it has something to do with the filter portion with the ALL and USERELATIONSHIP because the values are not changing when I remove that portion.
Does anyone know a solution to this?
1 Reply
Hi Slowpoke1 ,
what you are trying to acheive? (overall objective)
if you can share sample data as well this would be helpful
