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