Forum Discussion
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...
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 TeamIf 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
Anyone? 🙂