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 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

 

 

Need Help
Show and Tell

2 Replies

  • 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.