Hi,
I have some data that I am presenting in a dashboards that appears fine when I have it in a table, but when I want to show an average value for the dataset in a card, it is summing the values.
The data has required a lot of manipulation in Power BI, and I have performed the following steps to get it into the dashboard as it currently is.
It is looking at our customer data, measuring how much of it has been completed for different attributes. Data is at a customer row level, with customer information at a column level. There are about 40 different customer attributes that I am looking at.
I pivoted the customer attribute data, to have the data in 2 columns, attribute and value, which made it easier for me to calculate the % of attributes that had been completed using measures.
Knowing how many records each column should have, I was able to calculate a measure for the target value, then use this to calulculate the missing, and completion %.
These values work fine in the table, however, when I want to show the overall total, I am unable to, and it only shows the sum.
In the field drop down menu, I am not given the option to show the value at an aggregated average or other value.
When I place the % completed value in a Card visual, again it only shows the sum of the Value field, not allowing me choose an overall average. I'm not given the option of turning off Sumarization either.
Has anyone come across this before, and know how I might be able to show the average, or other aggregated values?
Thanks,
Andrew
