Forum Discussion

irenelitw629's avatar
irenelitw629
Helper II
4 years ago
Solved

DAX - VAR Measure help

Hi all,   I want to create a calculate measurement with VAR. Whenever account and BU workflow filters are selected, the measure will display corresponding closed amount.   Issue: when BU workflow...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    Hi,

    Please check the attached file.

    If no-select, then it is blank.

     

     

Jihwan_Kim's avatar
Jihwan_Kim
Super User
4 years ago

Hi,

I am not sure if I understood your question correctly, but please try the below measure.

 

Measure: =
VAR _acct =
    MAXX ( Sheet1, Sheet1[Account Name] & 'Sheet1'[BU Workflow FY22] )
RETURN
    IF (
        ISFILTERED ( Sheet1[BU Workflow FY22] ),
        CALCULATE (
            SUM ( Sheet1[USD Closed] ),
            FILTER (
                ALL ( Sheet1 ),
                Sheet1[Account Name] & 'Sheet1'[BU Workflow FY22] = _acct
            )
        )
    )