Forum Discussion

dieterbe_vdb's avatar
dieterbe_vdb
Frequent Visitor
2 years ago

Different behavior Table and Matrix

I have some issues with a Matrix visualisation.   Data (source) table: I want to visualize, using a matrix, the amount of customers based on both Status and Prio. Moreover, I want to calcu...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi dieterbe_vdb ,

 

Thanks for the reply from ThxAlot , please allow me to provide another insight: 

 

The hierarchical structure of the matrix is closely related to the context of the dax expression and, as a result, often causes some unexpected results. You can use dax expressions to create a dummy table and then perform calculations with the data in the dummy table to ensure the accuracy of the data.

MEASURE = 
VAR _SUMMARIZE =
    SUMMARIZE (
        ALLSELECTED ( 'Data' ),
        [Status],
        "Count", COUNT ( 'Data'[Customer ] )
    )
RETURN
    SUMX ( FILTER ( _SUMMARIZE, [Status] = MAX ( 'Data'[Status] ) ), [Count] )

 

If your Current Period does not refer to this, please clarify in a follow-up reply.

 

Best Regards,

Clara Gong

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