Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Filtering related data

Hey wonderful PBI community   I'm trying to look at unique moments and filter related moments on the same id to show how often those related moments occore when selecting an indivual moment.    f...
Need Help
Tips and Tricks
  • v-kkf-msft's avatar
    v-kkf-msft
    5 years ago

    Hi Anonymous ,

     

    Try the following formula:

     

    Measure = 
IF(
    ISFILTERED('Comparison Moment'[Comparison Moment]),
    [match %],
    DIVIDE(
        DISTINCTCOUNT(Main_Data_Set[id]),
        CALCULATE( DISTINCTCOUNT(Main_Data_Set[id]), ALL(Main_Data_Set) )
    )
)

     

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

    Best Regards,
    Winniz

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

lbendlin's avatar
lbendlin
Super User
5 years ago

Is your default interaction cross filtering or cross highlighting?

Anonymous's avatar
Anonymous
Not applicable
5 years ago

filtering, looking to click on one moment, then see those moments and how frequently they show up on the associated id's