Forum Discussion

tecumseh's avatar
tecumseh
Resolver III
1 year ago
Solved

Get Slicer Selected Items in Calculated Table

Hi, Using PBID Aug 2024. How to get a list of slicer selected items in a calculated table? The same slicer exists in different pages in report. How does Calculated Table know which slicer/page ...
Need Help
  • UncleLewis's avatar
    UncleLewis
    1 year ago

    Thanks parry2k 

    Converted to Measure and returning the correct result : 2

    Thanks,
    w

    Count of selected items =
    Var T1 = 
        CALCULATETABLE(
            VALUES('Calendar'[Quarter]),
            ALLSELECTED('Calendar'[Quarter])
        )

    RETURN
        COUNTROWS(T1)
parry2k's avatar
parry2k
Super User
1 year ago

UncleLewis you cannot create a dynamic table based on the slicer selection.