Forum Discussion

Analitika's avatar
Analitika
Post Prodigy
5 years ago

Filter all from filtered

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 ...
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
5 years ago

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's avatar
Analitika
Post Prodigy
5 years ago

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's avatar
    Anonymous
    Not applicable
    5 years ago

    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