Filtering a Table Visual with a Measure Value

[prabhatnath]

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 have another Measure-1 that store a calculated value based on the Slicer-1 selection (previous value of the selected value in the Slicer based on some condition).  

I have another report page in the same file that has the Slicer Synced from Page-1. I need to add a Table Visual in this page that should show data from Dataset-1 where  TextColumn-1 = Measure Value.

Please suggest how can I get this done.

Thanks,

Prabhat

[Anonymous]

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]

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]

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]

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