Total Sum as per different matrix selection

[Anonymous]

Total should be display (200+270=470) but it is not coming correct. if i select value from all for matrix (300+270+122+200 then it is display correct sum(like 892). if i select three matrix value then sum of three matrix value .only for all matrix selection it is working fine.For 1,2 ,3 matrix selection is not working.I need sum as per matrix selection.  please see below image.

[Anonymous]

Thanks MFelix, This measure is working fine . I replaced semicolon to comma.

I have one more question-I can't find any option to attach my pbxt file in community.

[MFelix]

Hi @Anonymous ,

The option to attach file is only for some specific group users but you can use a onedrive, google drive, we transfer or similar link to upload your files.

[Anonymous]

All matrix values are coming from different four table .

Hi MFelix,

All matrix values are coming from different four table .

For testing, I created measure using isfiltered but  it is not working for signle matrix  and  How can I put two isfiltered condition in this measure . If i want to select two phase I and 2 then it will display two phase sum.

[MFelix · Accepted solution]

Hi @Anonymous ,

I did the following measure:

Total =
IF (
    ISFILTERED ( Table_1 ) || ISFILTERED ( Table_2 )
        || ISFILTERED ( Table_3 )
        || ISFILTERED ( Table_4 );
    IF ( ISFILTERED ( Table_1[Week] ); SUM ( Table_1[Value] ); 0 )
        + IF ( ISFILTERED ( Table_2[Week] ); SUM ( Table_2[Value] ); 0 )
        + IF ( ISFILTERED ( Table_3[Week] ); SUM ( Table_3[Value] ); 0 )
        + IF ( ISFILTERED ( Table_4[Week] ); SUM ( Table_4[Value] ); 0 );
    SUM ( Table_1[Value] ) + SUM ( Table_2[Value] )
        + SUM ( Table_3[Value] )
        + SUM ( Table_4[Value] )
)

asically I'm checking if there is any matrix that is filtered if yes I only pickup the filtered values if none is filter I sum all the values.

Check PBIX file attach:

[MFelix]

Hi @Anonymous ,

Are the values on the matrix visualizations being picked up from diferrent table or is it all in the same table?

How do you have the sum setup?

How do the matrix visualizations interact between them and with the card?

Believe that your issue is related with the way you have the information and the visualizations setup.

If all the visualizations are coming from the same table but with different filters you may be getting context erros in the calculations so not return any values or incorrect.

Can you share a mockup file?