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] * 'percent'[PDGrade]) / sum('percent'[Tier1Exposure]), (FILTER( 'percent','percent'[ver]) ))
Need Help

3 Replies

  • 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