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 ...
Hi
am trying to compare a tender sum and a final cost on a series of projects - any suggestions how best to do this?
Is your data in different tables? If so, make sure your cross filter direction is set up both ways in the relationship view. I have one table with sales data, one with purchasing data and one project data. All have project ID number in them and relations go from one to another with cross filtering set in "both". If the cross filtering is "single", my sales amount values were shown as counted, not as per sales ID.