Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

All Not Ignoring Filter Slicer

https://rapidshare.io/57h/ex.pbix 

 

Goodmorning everyone,

 

I disturb you this time to know the possibility of keeping values in the table on power bi even after selecting a special filter.

 

In the example linked by me, it can be seen that with the choice of the filter, the values not affected by the filter itself disappear from the table.

 

Is it possible to keep all the values inside the table even if they are not linked with the selection filter?

 

Thanks in advance everyone and good luck

 

Best regards

 
Need Help
  • v-kkf-msft's avatar
    v-kkf-msft
    5 years ago

    Hi Anonymous ,

    Try the following formula:

    Measure = 
var tab = 
    SUMMARIZE(
        'Date',
        'Date'[CodiceDivisione],
        "_sum",SUM('Date'[ValoreNetto])
    )
return 
    CALCULATE(
        'Date'[test],
        FILTER(
            tab,
            'Date'[CodiceDivisione] = 'Date'[CodiceDivisione]
        )
    )

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

    Best Regards,
    Winniz

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

11 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks for the reply.

    But at the same time I have to insert another measure on which the filter must be applied. Consequently, I cannot completely exclude the filter from the table.

     

    Best regards

    • Portrek's avatar
      Portrek
      Resolver III
      5 years ago

      Yes, Select only the filter that you do not want to establish functions in your table, this does not interfere with the other filters.

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hi, the initial situation is reported above.

         

         

        The arrow in red represents the situation of my interest: the unfiltered values disappear but the total still reports the values