Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Not showing duplicates in visual

Hello everyone, Maybe someone can help me with this problem. I created a PieChart based on my dataset. The visual displays results of testcases with repect to a softwareversion. So some testcases w...
Need Help
Tips and Tricks
  • vojtechsima's avatar
    vojtechsima
    4 years ago

    Hi, Anonymous 

    Latest_Date = 
var MaxDate = CALCULATE(MAXX(Users,Users[Date]),
ALLEXCEPT(Users,Users[USER-ID]))
return MaxDate

    Is this something that would fulfil your request?

vojtechsima's avatar
vojtechsima
Icon for Super User rankSuper User
4 years ago

Hi, Anonymous,
it's possible to filter in visual using TOPN, see pictures:

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi, vojtechsima 

    This is not really what I am looking for. In your example the name or email is equivalent to my testcase. I need the last result for every name(testcase) and not the latest in total. So in you example if there would be a name more than once, than only show the one thats latest. But thanks for your effort.

     

    • vojtechsima's avatar
      vojtechsima
      Icon for Super User rankSuper User
      4 years ago

      Hi, Anonymous 

      Latest_Date = 
var MaxDate = CALCULATE(MAXX(Users,Users[Date]),
ALLEXCEPT(Users,Users[USER-ID]))
return MaxDate

      Is this something that would fulfil your request?

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        vojtechsima 

        This seems to be exactly what im looking for but if im using it, it doesnt remove the older values from the list. It just shows the latest date for both values. So still same amount of values...