cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Microsoft v-jiascu-msft
Microsoft

Re: AverageIF - Based on one category, combined with another average

Hi @JimmyDQN,

 

You can upload the file to a cloud drive like OneDrive, GoogleDrive then share the link here or send me a message through Messages. Please mask the sensitive parts first.

 

 

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
JimmyDQN Regular Visitor
Regular Visitor

Re: AverageIF - Based on one category, combined with another average

@v-jiascu-msft https://drive.google.com/open?id=1pGmwarQb1xM9o0HeCj3T096vksUGuomO here is the link. 

 

I couldnt, for some reason, make a realtionship from Geography. I had to export some data, as it is on a SSAS cube.

Microsoft v-jiascu-msft
Microsoft

Re: AverageIF - Based on one category, combined with another average

Hi @JimmyDQN,

 

Please check out the demo in the attachment. There are solutions both of "calculated column" and "measure". 

Though I don't know why there are duplicates in the Geography table which is thought to be a dimension table, the solutions work.

BTW, we can create a many-to-many relationship now.

averageif

 

 

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
JimmyDQN Regular Visitor
Regular Visitor

Re: AverageIF - Based on one category, combined with another average

I get an error trying to download this. But, I cannot make columns as I am on an SSAS cube. 

Highlighted
Microsoft v-jiascu-msft
Microsoft

Re: AverageIF - Based on one category, combined with another average

Hi @JimmyDQN,

 

Is it a Direct Query connection? I have updated the attachment. You can try it again.

 

 

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

JimmyDQN Regular Visitor
Regular Visitor

Re: AverageIF - Based on one category, combined with another average

Hi,

 

sorry for the late reply. 

 

It is correct that I am using direct query. I will try to look at this tomorrow 🙂 

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)