Forum Discussion

ripstaur's avatar
ripstaur
Helper III
5 years ago
Solved

Filtering out duplicates

So, this ought to be easy, but one of the caveats in the online training is that filters are not something a newbie like me will understand first time through.  So here's the setup - I have some fac...
Need Help
  • Icey's avatar
    Icey
    5 years ago

    Hi ripstaur ,

     

    Create a measure like so:

    Measure =
VAR t =
    SUMMARIZE (
        'Table',
        'Table'[Region],
        'Table'[County],
        "Total_", MAX ( 'Table'[County total cases] )
    )
RETURN
    SUMX ( t, [Total_] )

     

    BTW, .pbix file attached.

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

ripstaur's avatar
ripstaur
Helper III
5 years ago
1CWonderful364130812305
1BWonderful364158721856
1AWonderful364   
1DEagle160   
1FMockingbird96   
1ERobinette83   
1GCowpie60   
1HGeorgeana90   
1IDraggit149   
1JLackett152   
1KPickit154   
2LSimpson269   
2MSimpson269   
2NRonson190   
2OJohnson129   
2PAlbemarle120   
2QJohannesburg177   
2RKimtown168   
2SPopular132   
2TWilherm190   
2USampson101   
2VFuchness111   
       
ripstaur's avatar
ripstaur
Helper III
5 years ago

Now I see that the column headers didn't paste in...column A is Region, B is Facility, C is County D is County total cases, E contains the regional totals I want, F is region titles and G is the totals I'm getting now because of the duplicates. I have tried just specifying county totals, but since there are three entries for Wonderful County it adds them all together.