Measure divided by another measure doesn't calculate correctly

[DaveW]

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.

[v-eachen-msft]

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.

[Greg_Deckler]

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