Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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...
  • Fowmy's avatar
    Fowmy
    6 years ago

    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 šŸ™‚

    YouTube, LinkedIn

Fowmy's avatar
Fowmy
Super User
6 years ago

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 šŸ™‚

YouTube, LinkedIn

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks a lot! 
    I feel like I've tried very similar techniques but never got it right, I knew it was going to be something simple..