topic Re: Using Slicer filter to filter a matrix way to calculate in DAX Commands and Tips

Using Slicer filter to filter a matrix way to calculate

Anonymous — Wed, 10 Mar 2021 13:16:44 GMT

Hi everyone.

I need help with i have a table with data and a column called "country" - that has all european country plus one entry called "Europe".

What i need to know is if there's a way to when on the slicer I select "ALL" the calculations on the table shows the values of "Europe", instead of the summarization of all countries plus the Europe row.

Thank you in advance for your help.

Re: Using Slicer filter to filter a matrix way to calculate

amitchandak — Wed, 10 Mar 2021 13:42:34 GMT

Anonymous , Try a measure like

if(isfiltered(table[country]), count(Table[Value]), calculate(count(Table[Value]), filter(Table, Table[country] ="Europe")))

Re: Using Slicer filter to filter a matrix way to calculate

Anonymous — Wed, 10 Mar 2021 17:16:24 GMT

amitchandak, didn't worked.

My structure is

Table 1 - COD_CTRY with only a Column with all the European countries plus one entry called Europe.

Table 2 - TBL_Values with two columns Country and Values

When I filter the COD_CTRY in the slicer for example "Austria" the data should be the value for Austria, and when i remove the filters so the slicer has "All" the Europe value should appear, and you solution always shows the Europe value.

sorry i had to re-arrange the tables.