Total by different Dimension

Anonymous , For Distinct Count > 1

Try like

sumx(filter(Values( Tow[Job Number]) , [Distinct Counts] >1),[Distinct Counts])

distinct count can behave differently based on group by

Hi, Anonymous 

Please correct me if I wrongly understood your question.

please try to write measure like below.

Measure = 

VAR _newtable = filter ( summarize (table, jobnumber column, "@totalcount", your total count measure) , [@totalcount] >1)
RETURN

sumx (_newtable, [@totalcount])

If it is Ok with you, please share your sample pbix file, then I can try to come up with a

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster.

more accurate measure.

Thank you.