Forum Discussion
Dax expression with filter
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] * 'perc...
Thank you for your help, I tried it as a measure and I got the below error message.
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