Forum Discussion

LoganFFS's avatar
LoganFFS
Frequent Visitor
1 year ago
Solved

DAX Measure

I have a measured column in a data table with the following code:   ClientCategorySum =          SUM('Trades'(adjustedgrossamount)),         FILTER(                   ALLSELECTED('Trades'),    ...
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi LoganFFS ,

     

    I used some sample data on my side and tried to reproduce the issue, but it's working fine for me. I used following measures.

    ClientCategorySum = 
CALCULATE(
    SUM('Trades'[adjustedgrossamount]),
    FILTER(
        ALLSELECTED('Trades'),
        'Trades'[ClientLastName] = SELECTEDVALUE('Trades'[ClientLastName]) &&
        'Trades'[Category] = SELECTEDVALUE('Trades'[Category])
    )
)

    ClientCategorySumSignFilter = 
VAR SelectedSign = SELECTEDVALUE(MeasureFilter[Sign])
VAR ClientSum =
    CALCULATE(
        SUM('Trades'[adjustedgrossamount]),
        FILTER(
            ALLSELECTED('Trades'),
            'Trades'[ClientLastName] = SELECTEDVALUE('Trades'[ClientLastName]) &&
            'Trades'[Category] = SELECTEDVALUE('Trades'[Category])
        )
    )
RETURN
    SWITCH(
        SelectedSign,
        "Positive", IF(ClientSum > 0, 1, 0),
        "Negative", IF(ClientSum < 0, 1, 0),
        1
    )

    expected output: 

    Hope this helps. Please reach out for further assistance.

     

    Thank you.

     

LoganFFS's avatar
LoganFFS
Frequent Visitor
1 year ago

Hi there, sorry for my absence from the forum here. I am not authorized to open a Pbix file on my computer here so is there a way you can provide the measures code written in the response? If you are able to do that it would be hugely appreciated. Thanks and sorry once again for my absence. 

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi LoganFFS ,

 

I used some sample data on my side and tried to reproduce the issue, but it's working fine for me. I used following measures.

ClientCategorySum = 
CALCULATE(
    SUM('Trades'[adjustedgrossamount]),
    FILTER(
        ALLSELECTED('Trades'),
        'Trades'[ClientLastName] = SELECTEDVALUE('Trades'[ClientLastName]) &&
        'Trades'[Category] = SELECTEDVALUE('Trades'[Category])
    )
)

ClientCategorySumSignFilter = 
VAR SelectedSign = SELECTEDVALUE(MeasureFilter[Sign])
VAR ClientSum =
    CALCULATE(
        SUM('Trades'[adjustedgrossamount]),
        FILTER(
            ALLSELECTED('Trades'),
            'Trades'[ClientLastName] = SELECTEDVALUE('Trades'[ClientLastName]) &&
            'Trades'[Category] = SELECTEDVALUE('Trades'[Category])
        )
    )
RETURN
    SWITCH(
        SelectedSign,
        "Positive", IF(ClientSum > 0, 1, 0),
        "Negative", IF(ClientSum < 0, 1, 0),
        1
    )

expected output: 

Hope this helps. Please reach out for further assistance.

 

Thank you.