Forum Discussion

Tamerlaaane's avatar
Tamerlaaane
Frequent Visitor
3 years ago
Solved

Request for help with DAX measure

Hi everyone,   I am having issues calculating a SUMX with a filter > 0 on a measure that is also being affected by period selection. Data model is a nice star schema with a Fact table where all the...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Tamerlaaane ,

    Please try this measure.

    Measure = 
SUMX (
    FILTER (
        SUMMARIZE (
            'dim_date',
            'dim_date'[Date],
            "DBD", [Balance (at the end of the period)] - [Average allowed balance]
        ),
        [DBD] > 0
    ),
    [DBD]
)

     

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Tamerlaaane ,

Please try this measure.

Measure = 
SUMX (
    FILTER (
        SUMMARIZE (
            'dim_date',
            'dim_date'[Date],
            "DBD", [Balance (at the end of the period)] - [Average allowed balance]
        ),
        [DBD] > 0
    ),
    [DBD]
)

 

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

Tamerlaaane's avatar
Tamerlaaane
Frequent Visitor
3 years ago

Thanks so much, this works!