Forum Discussion

elenton's avatar
elenton
Helper II
6 years ago
Solved

Exclude Data from one level of Matrix

Hi Is there a way to have a matrix that has the following structure, but removes the top level of data from the calculations without having to go and exclude them from evey measure created: Top...
Need Help
Tips and Tricks
  • elenton's avatar
    elenton
    6 years ago

    Sorry I thought I have deleted this post, i figured out a solution in the end. I basically wanted an exclude filter to be applied to some levels of the data without having to write new measures.

     

    I added a column for each level of the data in the end that i can then pull into the filter pane to use as an exclude measure which has worked as i needed.

v-xuding-msft's avatar
v-xuding-msft
Community Support
6 years ago

Hi elenton ,

I don't get you. Can you please share some sample data and your expected results? Then we will understand clearly about your request.

 

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

elenton's avatar
elenton
Helper II
6 years ago

Sorry I thought I have deleted this post, i figured out a solution in the end. I basically wanted an exclude filter to be applied to some levels of the data without having to write new measures.

 

I added a column for each level of the data in the end that i can then pull into the filter pane to use as an exclude measure which has worked as i needed.