How to make chart ignore filter in matrix headers?

[felsilveira]

Hi all,

I am trying to make a chart with indicators that also are headers of  a matrix. My dataset has 4 variables (Date, Indicators  (A,B,C,D), Currency and Value). I have a matrix where the rows are the "Currency", the columns are the Indicators A and B and the values are "Value". In my chart, the axis is Indicators (C and D), the legend is the "Currency" and the values is "Values". I want to make this chart ignore what is selected in the matrix columns but I need it to be responsive to the matrix rows (currency). How can I do it?

I the Fig 1, we can see the screen if no filter is selected. And I want to select a currency (row) or a value in the matrix. But if I do it, my chat turns blank (FIg 2) where I want to see the values of C and D for the selected currency.

All files and data are here . 

Thanks very much

[v-lili6-msft]

hi, @felsilveira 

And for you select a currency (row) or a value in the matrix. But chat turns blank, please check if there is any visual/page/report level filter in the chat visual.

I find that it works well in you sample pbix file.

Best Regards,

Lin

[v-lili6-msft · Accepted solution]

hi, @felsilveira 

You could use “all” functions in DAX: ALL, ALLSELECTED, ALLNOBLANKROW, ALLEXCEPT.

For valor value

Measure = CALCULATE(SUM(dados[valor]),ALL(label))

Best Regards,

Lin