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.

v-kkf-msft's avatar
v-kkf-msft
Community Support
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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    so this doesn't seem to quite work as expected. 

     

    the top graph should be in the 80% range when un-filtered. 

    • v-kkf-msft's avatar
      v-kkf-msft
      Community Support
      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]), ALLSELECTED('Main Moment'[Main Moment]), ALL(Main_Data_Set[date]) )
    )
)

       

       

      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

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        So what I'm going for is when I slect Product x4 for example is to see only the tickets with those id's and if those tickets have Positive or Negitive sentinement so the count of either could be a max of 3 in this example