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?

Anonymous's avatar
Anonymous
Not applicable
4 years ago

vojtechsima 

I think this wont work, because I have a lot more versions and results and testcases in my dataset. And in my visual I only want to do this for selected versions nad if I would do a calculated column it would a lot of times filter out the results I want because its not the latest result in total but it would be latest on selection. Yout other solution would suite better if it wouldnt still display all results in my case.

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.