Forum Discussion

PBI_AMS's avatar
PBI_AMS
Icon for Helper I rankHelper I
1 year ago
Solved

Slicing a visual while excluding the selected value from the visual

I am analyzing subscriber data.  I have 100k plus subscribers who have opted into up to 10 topics. What I want to be able to see is: If you are a subscriber to topic C, what OTHER topics are you also...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi PBI_AMS ,

    Thanks for reaching out to the Microsoft fabric community forum.

     

    Try this DAX measure :

     

    ExcludedTopics =
    VAR SelectedTopics =
        VALUES(ContactFilterTable[SelectedTopic])

    VAR HasSelection =
        COUNTROWS(SelectedTopics) > 0

    VAR SelectedContacts =
        CALCULATETABLE(
            VALUES(ContactOutputTable[ContactGUID]),
            ContactOutputTable[Topic] IN SelectedTopics
        )
    RETURN
    IF(
        HasSelection,
        CALCULATE(
            COUNTROWS(ContactOutputTable),
            FILTER(
                ContactOutputTable,
                ContactOutputTable[ContactGUID] IN SelectedContacts &&
                NOT(ContactOutputTable[Topic] IN SelectedTopics)
            )
        ),
        0
    )


    Find the below Attached .pbix file for your reference.

    If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it

    Best Regards,
    Sreeteja.
    Community Support Team 





Anonymous's avatar
Anonymous
Not applicable
1 year ago

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

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi PBI_AMS ,

Just wanted to check if you had the opportunity to review the suggestion provided?

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi PBI_AMS ,

    I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.