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?

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
4 years ago

Anonymous That seems like a Lookup Min/Max situation:

 

Measure Lookup Max Simple = 
    VAR __Table = 'Table3'
    VAR __Max = MAXX(__Table,[Column1])
RETURN
    MAXX(FILTER(__Table,[Column1] = __Max),[Column])

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Greg_Deckler ,

    thanks for your idea, but it doesnt seem to work the way I need it to. Lets say I have two results of testcases with same ID but on different versions.  I need the measure to filter out the one thats older. I tried your approach and its just showing the date of the result in the table instead of removing it. i had the ideo to assign 1s and 0s to it and than filter after 1s for the latest but dont really know how to do this with a measure.

    • Greg_Deckler's avatar
      Greg_Deckler
      Icon for Community Champion rankCommunity Champion
      4 years ago

      Anonymous Hard to be specific without sample data and expected output. Sorry, having trouble following, can you post sample data as text and expected output?
      Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

      Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

      The most important parts are:
      1. Sample data as text, use the table tool in the editing bar
      2. Expected output from sample data
      3. Explanation in words of how to get from 1. to 2.

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Greg_Deckler 

        TC_IDVersionDateIsLatestResult
        123.310.10.2021     0
        125.320.10.2021     1
        223.310.10.2021     1
        324.215.10.2021     1

        Sorry that I cant show real sample data. But the idea goes like this. Where the IsLatestResult is the Measure. My PieChart should than only show the values that have 1s.