I want to create a DAX formula that calculates the average price of product category.
I have the following SALES table, I want DAX to sum the prices for each category and divide it by the number of category present in my dataset.
Mathematically, it will be like this:
Sum of Clothing = 47
Sum of Electronics = 1300
Sum of Home = 250
Average by Category = 532.33
If want to filter from another table for one category the sum is the same as the average because it will divide by one.