Forum Discussion
Solved
Power BI Doing Division Incorrectly
Hi everyone, I'm trying to make a very simple "average number of support tickets per month" calculation. I have the following: Avg Tickets Per Month = DIVIDE( COUNTROWS(Table), DI...
Oaabwen42 , Make sure there is no visual level filter on that card
Try this measure for count distinct
countrows(values(Table[YearMonth]))
Hi Oaabwen42 ,
are you using table or card visual ? would you please share sample pbix or sample data?
Hi,
I'm using a card visual. I can't share the sample pbix or data, but you can see what's happening in this screenshot:
Tickets = 52, Months = 9, therefore DIVIDE(52, 9, 0) = 5.77, but it returns the wrong number.
Oaabwen42 , Make sure there is no visual level filter on that card
Try this measure for count distinct
countrows(values(Table[YearMonth]))