Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi @siewwei ,
Please try adding the ALL function to the first formula.
TodayProgressBilling(Buyer) =
SUMX(
FILTER(ALL(IFCA_AR_Trx_All),
IFCA_AR_Trx_All[Element Code] = "Progress Billing" &&
NOT(ISBLANK(IFCA_AR_Trx_All[Document No])) &&
IFCA_AR_Trx_All[Buyer Financier Billing] = "Buyer" &&
IFCA_AR_Trx_All[CreateDate] = [latest selected date]
),
IFCA_AR_Trx_All[DocumentAmt]
)
Please refer to the following documents for more information.
Managing “all” functions in DAX: ALL, ALLSELECTED, ALLNOBLANKROW, ALLEXCEPT - SQLBI
How to Use ALL in a DAX Expression in Power BI - RADACAD
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
it return no value (blank) to me with above formula
Hi @siewwei ,
If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.
Best Regards,
Neeko Tang
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
93 | |
85 | |
83 | |
72 | |
49 |
User | Count |
---|---|
142 | |
139 | |
110 | |
69 | |
55 |