Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Getting average of other similar entries based on drilled through target

I am looking to make a chart that compares a given locations emission values to other similar locations, where if I drill-through to the page on a given location, it will then have the chart show it's emissions as well as the average for all locations that match the same subtype, date range, and some other information:

 

FacilityProvinceSubtypeDateEmissions
Facility AAB1Jan-2110
Facility AAB1Feb-2120
Facility AAB1Mar-2120
Facility AAB1Apr-2110
Facility AAB1May-2140
Facility AAB1Jun-2110
Facility AAB1Jul-2120
Facility AAB1Aug-2120
Facility BAB2Jan-2120
Facility BAB2Feb-2130
Facility BAB2Mar-2130
Facility BAB2Apr-2150
Facility BAB2May-2140
Facility CSK2Jan-2160
Facility CSK2Feb-2150
Facility CSK2Mar-2160
Facility CSK2Apr-2140
Facility CSK2May-2140
Facility CSK2Jun-2160
Facility CSK2Jul-2180
Facility DSK2Jan-2150
Facility DSK2Feb-2170
Facility DSK2Mar-2160
Facility DSK2Apr-2160
Facility EAB1Jan-2120
Facility EAB1Feb-2110
Facility EAB1Mar-2110
Facility EAB1Apr-2120
Facility EAB1May-2110
Facility FAB1Jan-2150
Facility FAB1Feb-2110
Facility FAB1Mar-2130
Facility FAB1Apr-2130
Facility FAB1May-2140
Facility FAB1Jun-2180

 

So essentially, if I drilled into this page on Facility A, I would see it's average emissions (18.75) compared to the average of all facilities in AB with type 1 (24.211)

Whereas if I drilled into facility F I would see it's average (40) compared to the same 24.211

Drilling into C i would have it's average compared to other SK locations of type 2, etc etc.

 

I would like to be able to visualize this in maybe some different ways, such as selecting a location owner and seeing all of their locations compared to their respective averages at once, so maybe just creating a column in the table with this average would be the best approach

2 REPLIES 2
v-binbinyu-msft
Community Support
Community Support

Hi @Anonymous ,

I'm a little confused about your needs, Could you please explain them further? It would be good to provide a screenshot of the results you are expecting and desensitized example data.

Thanks for your efforts & time in advance.

 

Best regards,
Community Support Team_Binbin Yu

 

Anonymous
Not applicable

I forgot to mention, I would like to be able to have this average change based on the date range I am trying to view, i.e able to select Facility A during January 2021 and seeing it compared to the average of other locations during January 2021 only, or selecting a full year or all-time etc, and seeing only the average over that time period

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.