Dax question to sum unique row

[Anonymous]

Hi all,

I have a DAX problem hope you can help.  For example, I have a table (query) below:

I want to create a Measure Object to SUM only the row flagged as "Consider this for the sum".. hence the total sum value should be 21 not 62. 

I don't want to solve this in background query but using DAX. May I know if you have a clue. Thanks.

[Anonymous · Accepted solution]

Hi, @Anonymous 

You can create a measure:

Total = SUMX(DISTINCT(Sheet1[Vendor No]),FIRSTNONBLANK(Sheet1[Value],0))

It returns the first non-blank value for all distinct Vendor No and sum it up.

Paul,
Best

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

[nahid3152]

HI,
Use this Dax
Value for Consider =
CALCULATE(
SUM('Sheet1'[Value]),
'Sheet1'[Flagge] = "Consider this for the sum"
)