Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Team
Solved! Go to Solution.
Hi @Anonymous
Would you mind trying below formula?
Measure = var a = CALCULATE(SUM(RetailAudit_StockCount[Face_On]),FILTER(RetailAudit_StockCount,[Face_On]>=0)&&[MAX_DT]<=SELECTEDVALUE(RetailAudit_StockCount[StockCount_CreatedDate]) Return Round(a,2)
If still not work, please kindly share your dummy pbix/simple worksheet.
Hi @Anonymous
Your capture is not complete for us to generate the determinate result. based on your formula. I'd like to make some change:
column = ROUND(IF([MAX_DT]<=SELECTEDVALUE(RetailAudit_StockCount[StockCount_CreatedDate]),SUMX(FILTER(RetailAudit_StockCount,[Face_On]>=0),[Face_On]), ,2)
If your problem still exists, please share us your dummy pbix or simple data with clear logic.
Thanks for your Reply
we are using live connection if max_ date then display Stock count
we side create always messare only
above measure working fine but didt display ROW total i think as per formula using DAX small restriction above please help
Hi @Anonymous
Would you mind trying below formula?
Measure = var a = CALCULATE(SUM(RetailAudit_StockCount[Face_On]),FILTER(RetailAudit_StockCount,[Face_On]>=0)&&[MAX_DT]<=SELECTEDVALUE(RetailAudit_StockCount[StockCount_CreatedDate]) Return Round(a,2)
If still not work, please kindly share your dummy pbix/simple worksheet.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |