Forum Discussion

Josh0112's avatar
Josh0112
New Member
2 years ago
Solved

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       ...
Exclusion rule in DAX
  • vicky_'s avatar
    vicky_
    2 years ago

    This DAX measure worked for me:

     

    Average of NPS when theme not included =
var themeNotIncluded = FILTER(ALL('Table'), 'Table'[Theme] <> SELECTEDVALUE('Table'[Theme]))
return AVERAGEX(themeNotIncluded, 'Table'[NPS])

     

vicky_'s avatar
vicky_
Super User
2 years ago

This DAX measure worked for me:

 

Average of NPS when theme not included =
var themeNotIncluded = FILTER(ALL('Table'), 'Table'[Theme] <> SELECTEDVALUE('Table'[Theme]))
return AVERAGEX(themeNotIncluded, 'Table'[NPS])

 

Josh0112's avatar
Josh0112
New Member
2 years ago

Thanks, this seemed to do the trick. 

  • vicky_'s avatar
    vicky_
    Super User
    2 years ago

    Nice! Glad to help