Dax Help

[sarath_chandra]

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 users too (for example , region 1 user viewing the report means it should the min value of region 1 alone and should not show the values of other region).Above (first table is my data source )

i need to achieve second one based on region users

[Anonymous]

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.

[sarath_chandra]

please help 🙏@Ibendlin @Ahmedx  @DOLEARY85 @amitchandak