topic Sum values and filtering on distinct values from other column in DAX Commands and Tips

Sum values and filtering on distinct values from other column

maneschr2022 — Mon, 24 Oct 2022 04:23:09 GMT

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!

Re: Sum values and filtering on distinct values from other column

ValtteriN — Mon, 24 Oct 2022 06:57:38 GMT

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/