Sum values and filtering on distinct values from other column

[maneschr2022]

I have this measure that I'm using in a card visual

Measure = format(calculate(sum(Table1[ColumnX),Table1[ColumnH]=1) + 0,"#,##0") & max('Table2 Measure'[ColumnB])

I want to add to this measure a filter to only do this measure based on distinct values of Table3[columnP], as there are some duplicates row in the dataset.

How can I achieve this?, thanks!

[ValtteriN · Accepted solution]

Hi,

You can achieve this by using distinct + sumx. E.g. 

DAX:

Measure 20 =

SUMX(DISTINCT('Table (9)'),'Table (9)'[Value])

DISTINCT will remove duplicate rows in the calculation.

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/