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

Anonymous 
I see your point, however, without precise and specific conditions and requirements for the visualisations, I cannot help more.
Tho, you can also create a Calculated Table, with only the Latest Dates, that way you can display the request visualisation.

IsLatestResultCheck = 
var latestdate = CALCULATE(MAXX('Table','Table'[Date]),ALLEXCEPT('Table','Table'[TC_ID]))
var MaxedTable = CALCULATETABLE('Table', FILTER('Table','Table'[Date]=latestdate))

return MaxedTable

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

vojtechsima 

No worries. Thanks for your help anyways, for now I will accept your solution as it seems to be really close to what I need. thank you.