Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
92 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |