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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

HI Anonymous ,

 

Not very clear.

Can you share a sample .pbix or sample data in text format.

 

Regards,

Harsh Nathani

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hey,

 

Okay I tried converting my data in sample data, hopefully, this makes it more clear. The data shown is limited, but I assume it should be enough to make my point. 

 

.pbix Sample File 

 

I added the needed tables for information:

 

- I want to calculate the average of times Product Type appears per Store, divided by the amount of Store Visits.

=>This way I want to have a sort of weighted average to compare how often a Product Type appears in each store.

 

- The way it calculates the average now: It doesn't divide the total times the Product Type appears, by the total amount of Store Visits, just by the amount of Store Visits whereby this Product Type was registered.

 

I hope this makes more sense now...

 

Thanks in advance, internet wizards!