Forum Discussion
LoganFFS
1 year agoFrequent Visitor
DAX Measure
I have a measured column in a data table with the following code: ClientCategorySum = SUM('Trades'(adjustedgrossamount)), FILTER( ALLSELECTED('Trades'), ...
- Anonymous1 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.
Anonymous
1 year agoNot applicable
Hi @LoganFFS ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
Thank you.