Forum Discussion

xiumi_hou's avatar
xiumi_hou
Post Partisan
6 years ago
Solved

Need immediate support for dax function

Dear all,    I have attached my pdix file.    I need the dax function by two aspects: 1. First I want to create a bar graph, I want to pick the last session date's data(by id, which i have alre...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    Hi xiumi_hou 

    For question 2,

    create a measure, then add this measure to the visual level filter of the bar chart.

    rank = RANKX(ALLSELECTED(Sheet1),CALCULATE(SUM(Sheet1[Value])),,DESC,Dense)

     
    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

Hi xiumi_hou 

For question1:

Based on the transformation in my previous post, create a measure, add this measure to the column/bar chart

Measure =
VAR maxdate =
    CALCULATE (
        MAX ( Sheet1[GAD.session_date] ),
        FILTER ( ALLSELECTED ( Sheet1 ), Sheet1[ID] = MAX ( Sheet1[ID] ) )
    )
VAR adjusted_value =
    CALCULATE (
        SUM ( Sheet1[Value] ),
        FILTER ( Sheet1, Sheet1[GAD.session_date] = maxdate )
    )
RETURN
    IF ( adjusted_value > 2, adjusted_value )
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.