Apply filter over multiple columns

[Anonymous]

Hi Team

I have a data set with 4 columns, Pillar, Level, Rank , Skill and Demand. There are duplicate records as there is Supply data as well. I need to find out a way to get only one demand for a set of Pillar - Level - Rank - Skill. 

this was possible using the below expression.

MeasureX = CALCULATE(SUMX(SUMMARIZE('ABC',
'ABC'[Pillar],
'ABC'[Level],
'ABC'[Skill],
'ABC' [Rank],
"SUMTABLECOLUMN",MAX('Data +Demand Whole Data'[Demand Count])),MAX('Data +Demand Whole Data'[Demand])))

But when i go up the levels, that is when i select ALL or when no filters are applied i get wrong answer. When that happens i need to sum up the demand for each skill, each rank, each level and each pillar values.

Any help or guidance here.

thanks

[v-qiuyu-msft]

Hi @Anonymous,

Please share some sample data and clarify corresponding desired results. 

Best Regards,
Qiuyun Yu