topic Re: Dax expression with filter in Developer

Dax expression with filter

22LACMT — Thu, 10 Nov 2022 20:35:08 GMT

Does anyone know why this is not working? the math is working but it is not filtering the population by the 5 different dates.

PDWAVG = CALCULATE(sumx('percent','percent'[Tier1Exposure] * 'percent'[PDGrade]) / sum('percent'[Tier1Exposure]), (FILTER( 'percent','percent'[ver]) ))

Re: Dax expression with filter

Anonymous — Fri, 11 Nov 2022 02:49:08 GMT

HI @22LACMT,

You can try to use the following measure formula if helps:

PDWAVG = VAR summary = SUMMARIZE ( ALLSELECTED ( 'percent' ), 'percent'[ver], "rate", 'percent'[Tier1Exposure] * 'percent'[PDGrade] ) RETURN CALCULATE ( SUMX ( summary, [rate] ) / SUM ( 'percent'[Tier1Exposure] ), ALLSELECTED ( 'percent' ), VALUES ( 'percent'[ver] ) )

If these also don't help, can you share a pbix or some dummy data that keep the raw data structure with expected results? They should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng

Re: Dax expression with filter

22LACMT — Tue, 15 Nov 2022 15:19:59 GMT

Thank you for your help, I tried it as a measure and I got the below error message.

Re: Dax expression with filter

Anonymous — Wed, 07 Dec 2022 09:43:38 GMT

Hi @22LACMT,

I think these fields may not include in the 'percent' table so Dax expression cannot invoke correspond fields values.

Can you please share a pbix or some dummy data that keep the raw data structure and dax formulas with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng