Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Dear All,
I am struggling to find the right way to compute a row total for the matrix table at the bottom.
My dataset has a structure similar to the one below:
While these are the measures that I am using to compute the monthly quantities for each series and the absolute difference to be visualized in the matrix:
Series A = SUMX(FILTER(Sheet1;Sheet1[Series]="A");Sheet1[Qty]) Series B = SUMX(FILTER(Sheet1;Sheet1[Series]="B");Sheet1[Qty]) Absolute difference = abs([Series B]-[Series A])
As you can see I would like to highlight the monthly absolute difference among the two series and the total of the absolute difference column. Correclty the DAX returns 0 for that row total but I would appreciate any suggestion to compute, maybe with another measure, the total of the absolute deviation (12 in this case).
Thank you for your help,
Rocco.
Solved! Go to Solution.
Hi Sean,
I have found a way around to solve my issue. I am using quite a long formula but it works now.
I am using VAR and RETURN to compute the same calculation for each month and then I compute the sum of all the results.
Your formula was not solving my issue but probably because I framed the question not 100% clearly.
Thanks a lot anyways,
Rocco.
Absolute Difference = IF ( ISFILTERED ( Sheet1[Date - Month] ), ABS ( [Series B] - [Series A] ), DISTINCTCOUNT ( Sheet1[Date - Month] ) )
Hi Sean,
I have found a way around to solve my issue. I am using quite a long formula but it works now.
I am using VAR and RETURN to compute the same calculation for each month and then I compute the sum of all the results.
Your formula was not solving my issue but probably because I framed the question not 100% clearly.
Thanks a lot anyways,
Rocco.
Hi Rocco,
I am sort of stuck with the same problem, do you mind sharing your solution to the problem ?
Regards,
Rushyendra C
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |