Forum Discussion

Cado_one's avatar
Cado_one
Icon for Resolver III rankResolver III
6 years ago
Solved

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

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

Tips and Tricks
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    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.

     

6 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    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's avatar
      Cado_one
      Icon for Resolver III rankResolver III
      6 years ago

      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's avatar
        v-eachen-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        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]
    )