Forum Discussion

193's avatar
193
Frequent Visitor
4 years ago

Total in Matrix

Hello guys,   is there a way to show a total for all columns? I have matrix with two columns but total is shown only for Actual column:   Thank you.  
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi 193 

Try this code.

New_5_Selection_type 193 = 
VAR _SELECTVALUE =
    VALUES ( 'Target/Actual Selection'[Target/Actual] )
RETURN
    IF (
        OR ( "Actual" IN _SELECTVALUE, "Target" IN _SELECTVALUE ),
        CALCULATE (
            SUM ( Data[Revenue] ),
            FILTER ( Data, Data[Target/Actual] IN _SELECTVALUE )
        ),
        IF ( "Diff." IN _SELECTVALUE, [3 Diff.] )
    )

By default, total will only show the sum of Actual and Target. I think you don't need the sum of Diff. at this time.

If you select Target and Actual in Slicer, result is as below.

If you only select Diff. Total will show sum of Diff.

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

193's avatar
193
Frequent Visitor
4 years ago

Thank you for your answer, RicoZhou,

 

 

but it is not what I want to accomplish. I want to have Total Column for each Target, Actual, Diff and Diff %.

 

Thank you.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi 193 

    Due to your data model, you could only get only one Total column in Matrix visual. My code will give you correct Total for each Target, Actual, Diff and Diff %. If you select multiple selections, it will give you sum of all selection you selected.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickl