Forum Discussion

rrhutch's avatar
rrhutch
Helper II
7 years ago
Solved

Measure Working in Table But Not Matrix

I have the following measure that is calculating correctly if I am displaying the data in a table visualization, but not if I am displaying that data in a Matrix visualization. Wondering if I could g...
Need Help
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
7 years ago

rrhutch,

 

Check if the fields dragged to Rows and Columns are included in ALLEXCEPT.

  • rrhutch's avatar
    rrhutch
    Helper II
    7 years ago

    Yes, that was the problem. So that raises one other question for me. I am looking for that measure to work even if I don't have all of those fields in the Matrix. I was thinking the the ALLEXCEPT would accomplish that, but looks like I was wrong. Any input on how to have the measure calculate based on that context even if the fields aren't being displayed in the visualization?