Filter all from filtered

[Analitika]

How to filter ALL values from ALLSELECTED items?

I used filter in slicer and count with measure Allselected, it is ok, i got ALLselected Total 

but now in matrix i need to select multiple items and show all matrix Total (previous Allselected Total)

https://file.io/UpPvB18ZWcrN

[Anonymous]

Hi @Analitika ,

As I tried to download your file, it had already been deleted... 

I created a sample pbix file base on your provided data, please check whether that is what you want. You can find the details in the attachment.

1. Create a measure to get the sum of column2 value

Measure = CALCULATE(SUM('Table'[Column2]),ALLSELECTED('Table'))

2. Go to Format ribbon, click "Edit interactions". Select the table visual, then select the no impact icon in the upper right corner of the card visual

Change how visuals interact in a Power BI report

Best Regards

[Analitika]

@Anonymous 

🤣 

this is not problem solving, i need meaure not interactions diabling.

Interaction is urgently needed!!!

As i need Always total + selected items on chart

[Anonymous]

Hi @Analitika ,

It only disable the interaction between table and card visual, namely, when select any one record in table, there is no effect on the card visual-- it only display the value for all selected items. Whether I misunderstood your needs? Could you please share your sample pbix file again since the previous one has been deleted? It is better if you can provide your expected result with more specific examples. Thank you.

Best Regards

[lbendlin]

Use separate measures to achieve these (conflicting) goals.