Dax expression with filter

[22LACMT]

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]) ))

[Anonymous]

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

[22LACMT]

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

[Anonymous]

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