Forum Discussion

22LACMT's avatar
22LACMT
Helper III
3 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

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's avatar
    22LACMT
    Helper III
    3 years ago

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

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      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