slicer not working with measure used in table visual

[Ephsiba]

datescount =

CALCULATE(

    COUNTROWS(DimDate),

    FILTER(

        Facts,

        Facts[Months] =Facts[Months]="DEC-NOV"

    ),

    REMOVEFILTERS(dimemps[Employee Name])

)

works correctly and gives the correct result. But when i change the slicer of Facts[Months] from DEC-JAN to NOV-DEC it doesnt work. 

I changed the code as 

datescount =

CALCULATE(

    COUNTROWS(DimDate),

    FILTER(

        Facts,

        Facts[Months],Facts[Months]=Selectedvalue(facts[Months])

    ),

    REMOVEFILTERS(dimemps[Employee Name])

)

It doesnt work. gives only empty values

[Anonymous · Accepted solution]

Hi @Ephsiba ,

Please Using month in Table as a slicer and try:

Table = SUMMARIZE(Facts[Months])

datescount =
CALCULATE(
    COUNTROWS(DimDate),
    FILTER(
        Facts,
        Facts[Months],Facts[Months]=Selectedvalue(Table[Months])
    ),
    REMOVEFILTERS(dimemps[Employee Name])
)

Please feel free to correct me and provide more information if I have misunderstood you!

An attachment for your reference. Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Ritaf1983]

Hi @Ephsiba 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523