How to take data from a column in a table and add to a matrix without it only giving a count of data

[HDD328]

Hello,

I have a report that will take downtime associated with a certain downtime code and display how many minutes per shift, per DT code we had on a particular day or days. Whenever I add the column with the minutes of downtime to the values on my matrix, it gives me a count of how many downtime code entries there were instead of the actual number of minutes per downtime code. I have been researching how to accomplish this with DAX, but have had no luck so far. Any help is appreciated. 

Below are screenshots for examples:

[NaveenGandhi · Accepted solution]

Hi @HDD328 

Can you change the aggregation from count to sum. 

Let me know if this works.

If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!

Follow me on LinkedIn!!!


LinkedIn