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)
UncleLewis's avatar
UncleLewis
Responsive Resident
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)