Forum Discussion

sarath_chandra's avatar
sarath_chandra
Helper III
3 years ago

Dax Help

I have material ,material type (AL,DT,EW) and four region wise(R1,R2,R3,R4) data .Based on region wise user, i have to show the min value of regions.I have to ride the min values for other region use...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi sarath_chandra 

You can refer to the following example

1.Unpivot the table to the following picture

 

2.Create a calculated table

Table 2 =
VAR a =
    SUMMARIZE (
        FILTER ( ALLSELECTED ( 'Table' ), [MA] IN VALUES ( 'Table'[MA] ) ),
        [MA],
        [Type]
    )
VAR b =
    SUMMARIZE ( ALLSELECTED ( 'Table' ), [Region] )
RETURN
    ADDCOLUMNS (
        GENERATEALL ( a, b ),
        "minvalue",
            MINX (
                FILTER (
                    ALL ( 'Table' ),
                    [MA] = EARLIER ( 'Table'[MA] )
                        && [Region] = EARLIER ( 'Table'[Region] )
                ),
                [Value]
            )
    )

Then create a measure

Measure = SUM('Table 2'[minvalue])

Put the column of table2 and the measure to the matrix visual

 

Best Regards!

Yolo Zhu

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