Filter department when selecting particular department

[SaratNitturi]

Fill Rate Beverage =
IF (
    ISFILTERED('Weekly OTIF'[Table.Mapping]),
    IF (
        SELECTEDVALUE('Weekly OTIF'[Table.Mapping]) = "Beverage",
        [% Fill Rate],  
        ""
    ),
    [% Fill Rate - Beverage]
)

There are three departments such as Beverage, Pacific, PF-Dry
when selecting Beverage department in slicer it displays data in matrix visual which contains the measure - "Fill Rate Beverage"
 when selecting pacific it gives Pacific data, but when selecting two departments in slicer it shows blank, when selecting more than one department it shows blank.
Need to see data when one or more than one department is selected in the slicer.
Thanks in advance
can you please help me out 

[parry2k]

@SaratNitturi can you share pbix file?

[SaratNitturi]

Still i am facing same issue.
When selecting single department the Matrix visual shows data but when i am selecting multiselection in the department slicer it shows blank.

[parry2k]

@SaratNitturi not sure who you are visualizing but try to change it to this:

Fill Rate Beverage =

    IF (
        SELECTEDVALUE('Weekly OTIF'[Table.Mapping]) = "Beverage",
        [% Fill Rate - Beverage]
        [% Fill Rate]
)

👉 Learn Power BI and Fabric - subscribe to our YT channel - @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤️