Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hey there,
I've got 2 tables, first: Financials and the other Days
The Financials table has Measure1 to derive $ with certain IF conditions
The Days table has Measure2 for days
I've created Measure3 within Financials table - to get $ per day
Measure3 = DIVIDE([Measure1], SUM(Days[Days]) )
Measure1 and Measure2 show the correct results but Measure3 doesn't show the expected result.
Hi @DaveW ,
Could you please share your sample data and excepted result to me if you don't have any Confidential Information? Please upload your files to OneDrive for Business and share the link here.
Wait, is Measure 2 a measure or column? Is Days a Date? That would be bad. Perhaps try COUNT.
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
User | Count |
---|---|
80 | |
74 | |
63 | |
61 | |
45 |
User | Count |
---|---|
108 | |
98 | |
89 | |
82 | |
61 |