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 ,
We haven’t received an update from you in some time. Could you please let us know if the issue has been resolved?
If you still require support, please let us know, we are happy to assist you.
Thank you.