cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
rdodworth Frequent Visitor
Frequent Visitor

Re: Help with sum of distinct count filter

this is what i have done in the past

CALCULATE (
        SUM ( Methods[F_Not_Covered_Lines] ),
        DISTINCT (
            SUMMARIZE (
                Methods,
                Methods[ModuleName],
                Methods[NamespaceName],
                Methods[ClassName]
            )
        )

 

So use summarize to summarize the data to the level you want above the grain-> wrap it in a distinct -> pass it as a filter to a calculate function and do your aggregation