Solved: Hi, can you help me about this DAX formula?

Anonymous · ‎08-26-2019

I have the following table

Type revenue cost

A 5 15

B 20 3

C 3 54

D 35 85

E 35 68

I would like to summarize the cost when the type =a or c or E so the final value in this case 137

Greg_Deckler · ‎08-26-2019

Well, if your underlying data table looks like what you posted, then this should work:

Measure = 
  SUMX(FILTER('Table',[Type] = "A" || [Type] = "C" || [Type] = "E"),[Cost])

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Anonymous · ‎09-02-2019

sorry for my late answers. thank you for your help. its working

Greg_Deckler · ‎08-26-2019

Well, if your underlying data table looks like what you posted, then this should work:

Measure = 
  SUMX(FILTER('Table',[Type] = "A" || [Type] = "C" || [Type] = "E"),[Cost])

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Hi, can you help me about this DAX formula?