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 

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

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