Forum Discussion
DAX Measure
- 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.
Hi LoganFFS,
DAX Measure - LoganFFS.pbix
Please check the above pbix file. Hope this help to solve the problem.
Please let me know if you have any further questions or need clarifications.
If this reply helped solve your problem, please consider clicking "Accept as Solution" so others can benefit too. And if you found it useful, a quick "Kudos" is always appreciated, thanks!
Best Regards,
Maruthi
LinkedIn - http://www.linkedin.com/in/maruthi-siva-prasad/
X - Maruthi Siva Prasad - (@MaruthiSP) / X
- LoganFFS1 year agoFrequent Visitor
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.