Forum Discussion
Incorrect Average Calculation
Hi everyone, I am very new to Power BI (and definitely to DAX) and I can't seem to figure out where the error is, hope someone out there can help me out! What I want to achieve, is getting an...
Anonymous
Can you try this measure please:Measure = DIVIDE( COUNT(DatalijstWinkelbezoek[Product Type]), CALCULATE( [#Storevisits], ALLSELECTED(DatalijstWinkelbezoek[Product Type]) ) )________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply 🙂
Your sample tables are inconsistent with your explanation. The first table shown seems to be an aggregate - we would need to see the raw data. The second table hopefully is just a visual as well. If not then you MUST unpivot it before proceeding.