Table visual edit interaction for values to change and keep all lines while using slicer

[Cado_one]

Hi,

I have a simple issue but I don't find the trick neither by myself nor by reading topics.

First let's explain my situation, I have the following table visual and slicer :

In the table, tracker is a real column from a database and the other columns are measures.

The slicer's values are calculated columns.

When I select lines in the slicer, the measures in the table adapt their value and all the lines trackers not selected disappear :

My problem is that I'd like to have all the lines of the table visible and measures value impacted by the slicer's selection.

When I edit interactions for the table not being filtered by the slicer, the table remain complete but its column values are not changing.

If someone know a trick that could help me with that I'd be very glad to try it !

Thanks in advance,

Cado

[amitchandak]

@Cado_one ,

You need to create a measure like that

create a formula like

measure =
calculate(if(line[line] in allselected(line[line]), [measure] null),all(lines))

[Cado_one]

@amitchandak 

thank you for the response, but can you add a little more detail please ? I'm not sure to understand what the lines refer to.

Should I replace with something like that ?

measure = calculate(if(Min('Données traitées'[tracker]) in allselected('Données traitées'[tracker]), [LossElec] null),all('Données traitées'[tracker]))

And then put this measure in my table ?

When trying this I got an error of "null" syntax incorrect

[v-eachen-msft]

Hi @Cado_one ,

You could create a new table as a slicer dimension. Then use ALLSELECTED() to get your filters and use IF() function to edit the selected results. Here is the measure for your reference.

Measure 2 =
VAR a =
    ALLSELECTED ( 'Slicer'[Column1] )
VAR b =
    ALLSELECTED ( 'Slicer'[Column2] )
RETURN
    IF (
        SELECTEDVALUE ( 'Table'[Column1] ) IN a,
        CALCULATE ( [Measure], FILTER ( 'Table', 'Table'[Column2] IN b ) ),
        [Measure]
    )

[Cado_one]

Hi @amitchandak @v-eachen-msft 

Thanks for the time tou take to help me. But I still don't make the match between 'Table', 'Measure' and my amount of measures and tables.

In the measure 2 @v-eachen-msft , does your [Measure] refer to @amitchandak measure in the last post or one of my measures ? And I have difficulties to see how my "new table as a slicer dimension" should be.

Sorry for lagging behind but my english is quiet bad and I'm a newbbie in Power BI

Thanks

Cado

[v-eachen-msft · Accepted solution]

Hi @Cado_one ,

The "Measure" I used means the measures of yours. You could select columns from your original table to create a new table as a slicer with SELECTCOLUMNS() function. This new table will be independent, so it will not filter your orginal table directly. Then use ALLSELECTED() function to get the range you want to compare.

[Cado_one]

@v-eachen-msft 

Thank you for your help, I finally managed by doing a copy of my data table as you said for the slicer and create a relation between the 2 "Tracker" columns. No need of a new measure.

Have a nice weekend !