Forum Discussion
Make a column not sum/count
I've used Power BI quite a bit lately with a SSAS cube and some Sql Server queries and created many visualiations. I am still fairly new to this though and cannot figure this out. I imported a ...
I've been beating my head up against a wall. I have a revenue total in one table, and an average in another table. Both are joined via a table with common fields. They work, as I can drag the fields from the common field, and everything works as it should.
No matter what I do, when I drag the average field from one table to a combo chart line value, it ALWAYS sums. I've tried the above help and told it not to summarize, but now it counts.
Is there any way to do this?
Thanks!
Rodger