Forum Discussion
Customized Matrix & SUM function & Customized Subtotals
Hi All,
This time I have got stucked with customised matrix.
The goal is to to have matrix with custom subtotal A+C = 8
________________________________________________________________________________________
input table with values
category table
model Category[Category]1-*Input[Letter]
functions:
A
B
C
A+C
In case I try to represent values on cards visualizatins I got folowing result
In case I try to represent values in matrix table I have difficulties to present A+C function
Thank you in advance for your reply.
Hi Anonymous,
could you try this for A+C:
A+C = SUMX(FILTER(ALLSELECTED(Input), Input[Letter] = "A" || Input[Letter] = "C"), Input[Value])Did this answer your question? Mark my post as a solution!
5 Replies
Hi Anonymous,
in your "Values for Matrix"-Measure you are using the Column "Input[Letter ]", and try to select "A+C",
As you state above this table does not include "A+C", only the "Category"-Table does.
So i would suggest swapping out SELECTEDVALUE(Input[Letter ]) for SELECTEDVALUE(Category[Category]) in the Values for Matrix"-Measure
Hope this helps.
Best regards,
Markus
Did this answer your question? Mark my post as a solution!
Hi Anonymous,
could you try this for A+C:
A+C = SUMX(FILTER(ALLSELECTED(Input), Input[Letter] = "A" || Input[Letter] = "C"), Input[Value])Did this answer your question? Mark my post as a solution!