Forum Discussion

bilalkhokar73's avatar
bilalkhokar73
Helper IV
4 years ago
Solved

Display message Matrix Level on Slicer

Team,   I have 3 Matrxi and both Mtarix table is connected with Single Slicer In slicer I gave C1, C2, C3, C3 If I Select C1 in Slicer  Then My Matrix 2 and Matrix 3 used to get blank becasue Mat...
Need Help
  • v-kkf-msft's avatar
    v-kkf-msft
    4 years ago

    Hi bilalkhokar73 ，

     

    Please add the following measures to the different matrices separately.

     

    Matrix_1 = COALESCE ( SUM ( 'Table'[Value] ), "you have selected C2/C3 you will not get data" )
    Matrix_2_3 = COALESCE ( SUM ( 'Table'[Value] ), "you have selected C1 you will not get data" )

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
    Best Regards,
    Winniz
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-kkf-msft's avatar
v-kkf-msft
Community Support
4 years ago

Hi bilalkhokar73 ，

 

Please add the following measures to the different matrices separately.

 

Matrix_1 = COALESCE ( SUM ( 'Table'[Value] ), "you have selected C2/C3 you will not get data" )
Matrix_2_3 = COALESCE ( SUM ( 'Table'[Value] ), "you have selected C1 you will not get data" )

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.