Forum Discussion
haniizz
Helper II
2 years agohelp with DAX calculation
Hello Community I need your help with performing this, I have this table ID Sex Age Finance status health status Mental Status 1 Male 20-30 good very bad good 2 Male 10...
ChiragGarg2512
Solution Sage
2 years agoCreate two measures[positive and negative] for every column. Then create 3 different tables or create a field parameter using all these measures and select 2 of the measure options to show in the table visual.
Here is the implementation:
6 measures were created[2 for each status] and then fed to field paramter that gave this slicer. Putting Sex and field paramter into table visual and selecting from slicer should provide this result.
Thank You.
ChiragGarg2512
Solution Sage
2 years agohaniizz , I tried my other 2 solutions but was not able to work with them, here is a solution(The last response has been edited).