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 and show all matrix Total (previous Allselected Total)

 

 

https://file.io/UpPvB18ZWcrN

Need Help
Show and Tell
Tips and Tricks

4 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

    Use separate measures to achieve these (conflicting) goals.

  • 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