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 ,

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