Value shows inaccurate when converted to a percentage

[PhillipC1]

Hello,

I have a value generated by a DAX formula which ultimately is pretty simple, but whenever I click to show the value as a percentage of column total, the values seem out of wack. This visual is filtered down to top 5 as well, just in case that matters.

Here is the table without the percentage showing. "Telematics Event by Employee" is generated by "Telematics Event" divided by "Count of EmployeeKey." As shown below, this seems accurate.

Here is the option I am selecting to convert to a percentage.

Once converted to a percentage, the values seem off. 

When I utilize excel, this is closer to what I would expect to see.

[Ritaf1983 · Accepted solution]

Hi @PhillipC1 
There is no option to format "automatic aggregations" if drag and drop.
So you need to create a dax measure for the wanted percentage.

You can use the Allselected DAX function for this goal.

For example if I have sales and categories this will look like :

% from total = DIVIDE([Total sales (K/$)], CALCULATE([total_sales],ALLSELECTED('Products'[Category])))

The pbix with the example is attached.
The video guide for using this Allselected is here :
https://www.youtube.com/watch?v=gD8yLTtyW1k&t=269s

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.