exclusion rule in dax
1 Topic
Simple DAX Query Question
I'm trying to create the following measure. I have two columns, one is a score and one is a text response. Like below NPS Theme 100 good 0 good -100 bad 100 other 100 bad 100 fun I want to be able to create a table that can show what the average of the NPS column would be if we didn't include each of the specific text themes. Something like below. Example for good theme would be (-100+100+100+100)/4 Theme Average of NPS when theme not included good 50 bad 75 other 40 fun 40 Just not sure where to start with this one. Any help would be greatly appreciated.Solved1.2KViews0likes6Comments