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...

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hey vojtechsima ,

      I have a Follow-Up question. is this also possible for only the selected values. I think this method refers to all values that are in Users. Can I also just refer to the values in table visual? So that the measure only takes these values into account instead of all?

      Thanks