Forum Discussion

prabhatnath's avatar
prabhatnath
Advocate III
2 years ago

Filtering a Table Visual with a Measure Value

Hello Friends, I have a Report from a single Dataset-1. It has a Slicer-1 representing a TextColumn-1 of the Dataset-1 and a Table Visual-1 that shows the data based on the Slicer-1 selection.   I...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi prabhatnath ,

If I understand you correctly, I'm afraid you will need to create a new table specifically for your slicer to more easily achieve your desired results.
Here are my sample datasets:

There is no relationship between the two tables:

I put this measure2 in the "Filters on this visual" of the table visual on page1:

Measure 2 = 
IF(
    ISFILTERED(Slicer[TextColumn]),
    IF(
        SELECTEDVALUE('Dataset-1'[TextColumn-1]) = SELECTEDVALUE(Slicer[TextColumn]),
        1,
        0
    ),
    1
)

 

This measure3 is then placed in the "Filters on this visual" of the table visual on page2:

Measure 3 = 
IF(
    ISFILTERED(Slicer[TextColumn]),
    IF(
        SELECTEDVALUE('Dataset-1'[TextColumn-1]) = 'Dataset-1'[Measure],
        1,
        0
    ),
    1
)

 

The results are as follows:


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

  • prabhatnath's avatar
    prabhatnath
    Advocate III
    2 years ago

    Thank you Anonymous  for the reply. This is working as expected.

    Unfortunately I will not be able to create separate table for Slicer as there are many visuals already using the same slicer.

     

    Or is there a possible to create measures that will list the values from specific column from Dataset-1 and use those measures in the TableVisual in Page 2 
    Or may be creating a Virtual Table using selecte columns with a condition for previous value?

    Thanks.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi prabhatnath ,

      I can find a workaround for you to display the value you need in page2 without creating a new table for slicer, but this method only displays one value, not the whole line.
      Put this measure into the table visual:

      Measure 4 = 
VAR SELECTED = 
CALCULATE(
    MAX('Dataset-1'[ID-1]),
    FILTER(
        ALL('Dataset-1'),
        'Dataset-1'[TextColumn-1] = SELECTEDVALUE('Dataset-1'[TextColumn-1])
    )
)
VAR A =
CALCULATE(
    MAX('Dataset-1'[TextColumn-1]),
    FILTER(
        ALL('Dataset-1'),
        'Dataset-1'[ID-1] = SELECTED - 1
    )
)
RETURN
CALCULATE(
    SUM('Dataset-1'[Value-1]),
    'Dataset-1'[TextColumn-1] = A,
    ALL('Dataset-1')
)

      The final output is below:

      Corresponds to page3 and page4 in the pbix file below.

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

      • prabhatnath's avatar
        prabhatnath
        Advocate III
        2 years ago

        Thank you for your help.
        As the need is to show the table with multiple columns and rows.

        Is there a way we can create measures for each column that we want to show in the table visual ? The new measure should be able to return multiple rows. Or a new dynamic virtual table. Just my thoughts.

         

        Thanks,

        Prabhat