Slicer DAX

Hi,

PBI file attached.

Hope this helps.

Hi smileamile2 

You can unpivot all other columns but Color in the query editor so Status and State values are in one column or you can use a disconnected table and use a measure as a visual filter.

Filter = 
CALCULATE (
    COUNTROWS ( 'Table' ),
    KEEPFILTERS (
        'Table'[Status]
            IN VALUES ( StatusOrState[Value] )
                || 'Table'[State] IN VALUES ( StatusOrState[Value] )
    )
)

Please see the attached sample pbix.

Hi smileamile2,
Thank you for posting your query in the Microsoft Fabric Community Forum.

May I ask if you have resolved this issue? If so, please mark it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

Hi smileamile2
,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

Hi smileamile2,

Could you please confirm if this issue has been resolved? If it has, kindly mark it as the solution and share the details in the community to help other members.
Thank you.