DAX and SUMX or/and COUNTX I guess

[JMSNYC]

Hi.

I have this problem, and I cannot write the DAX formula that gives me the desired answer. All formulas give me the average results.

Thank you for your help

[Nathaniel_C · Accepted solution]

HI @JMSNYC 

Try this, I created this calculated column and put it into a measure, to get your 7.

If this solves your issue, please mark this as the solution. Kudos are nice too!

@Nathaniel_C