Forum Discussion

claudia-amm's avatar
claudia-amm
Icon for Helper I rankHelper I
5 years ago

Show N value based on measure difference

Hi everyone.

 

I have two cards above displaying a distinct amount of User and Creator.
I need to show the value difference between those columns (User and Creator), which we can see clearly the difference is 4 (68 minus 64).
 
When I list the difference, the name shows 8 values (it's because values on User and Creator not same).
So, I am wondering if I can make the table to show only 4 name depends on the value difference (dynamic) but I don't know how to.
 
**I cannot share the data/sample due to confidential
 
If anyone can help.
Thanks a lot!

10 Replies

      • mahoneypat's avatar
        mahoneypat
        Icon for Microsoft Employee rankMicrosoft Employee

        Please generate some mock data that shows same issue and share that, to help suggest a specific expression.

         

        Regards,

        Pat

  • mahoneypat thanks for your explanation!! now, i'm wondering if i don't want to show all the 7 differences and  could only show 3 values? how can i do that? 

     

    Thanks

  • mahoneypat's avatar
    mahoneypat
    Icon for Microsoft Employee rankMicrosoft Employee

    It's just the reverse, but with the Creator column in the table visual.

     

    Creators Not Users =
    COUNTROWS (
        EXCEPT (
            VALUES ( 'List Creator'[Kreator] ),
            VALUES ( 'List User'[Name] )
        )
    )

     

    Regards,

    Pat

  • mahoneypat sorry i think my question isn't clear enough. what i meant by showing only 3 values is from this table:

    I tried to do it in reverse but the table gave me a different value which is this 

     

    This an example for the expected result:

    KorohCCC
    PeriyadiCCC
    RuntuweneCCC

     

    Thanks

     

     

    • mahoneypat's avatar
      mahoneypat
      Icon for Microsoft Employee rankMicrosoft Employee

      What is different about those three names to use in the logic to return just them?

       

      Regards,

      Pat

      • claudia-amm's avatar
        claudia-amm
        Icon for Helper I rankHelper I

        Could we add a new Index Column or random number to both table as a differentiator?