All Not Ignoring Filter Slicer

[Anonymous]

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

[Anonymous]

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]

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]

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

[v-kkf-msft]

Hi @Anonymous ,

First, after selecting "2020/1" in the AnnomesePianificazione column, I found that there is only one row and the ValoreNetto value is 0.

But the measure test you created shows a value of 7152329, so I want to know what is your purpose of creating the measure?

In order to get the correct output results, I created a Table to store the data in the CodiceDivisione column, and then established a one-to-many relationship between the Table and the Date table, and the cross-filtering direction was Single.

Create a Measure:

Measure = IF( ISBLANK( MAX('Date'[ValoreNetto]) ), BLANK(), [test] )

Then use the CodiceDivisione column of the Table as the rows of the matrix and the Measure as the value, and enable the option "Show items with no data", then get the following results.

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.

[Anonymous]

Hi, your solution is interesting but it doesn't solve my problem. My interest is to view all the data, even those not selected by the filter. In order to represent the total correctly.

[v-kkf-msft]

Hi @Anonymous ，

Sorry, I understand it wrong before.  Try the following formula:

Measure = 
    IF(
        HASONEFILTER('Date'[CodiceDivisione]), 
        SUM('Date'[ValoreNetto]), 
        SUMX( ALL('Date'), 'Date'[ValoreNetto] )
    )

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.

[Anonymous]

You as you can see from my attachment, the total does not correspond to the values that are displayed. The total must express all values, regardless of the selected filter.

[v-kkf-msft · Accepted solution]

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.

[Anonymous]

I would like that when I change the filter, nothing changes within the table. This is done by means of a measurement, not by means of power equipment.

[v-kkf-msft]

Hi @Anonymous ,

Could you give the output you want?

When the slicer select 2020/1, what is the specific result you want to output?

When the slicer select 2021/12, what is the specific result you want to output?

[Portrek]

Hi DS1

We need to manager the intercactions by the filter.

Look that microsoft page:

https://docs.microsoft.com/pt-br/power-bi/create-reports/service-reports-visual-interactions

Have a good day.