Sumx distinct over mulitple columns

[Invesco]

Hi Experts

I want to calculate the distinc values over the following columns (in blue) then sum unit column. How could i amend the following dax measure to achieve this.

Current measure

Result = CALCULATE(SUMX(DISTINCT(shc_table[Description]),FIRSTNONBLANK(shc_table[MarketUnits],0))

Distinct columns

[Anonymous · Accepted solution]

Hi @Invesco 

You can refer to the following ways.

You can create a mesaure

Measure=
var a=
SUMMARIZE('Table','Table'[descreption],'Table'[dataset_code],'Table'[element_hierachy_id],'Table'[rxa_brick_desc],'Table'[level_3_element_desc],'Table'[month_id],'Table'[level_3_market_desc]),'Table'[MarketUnits])
return sumx(a,[MarketUnits)

Best Regards!

Yolo Zhu

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