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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

Summary Table, Unique Counts, Graphs and Averages - How to incorporate them all?

In my PowerBI dataset I have many columns, but I am trying to build a graph using three columns from my dataset (Created Date, WO# and Part Number. I basically want to be able to show a graph that shows for any given year and month how many unique "WO#"s there were and the average "Part Number Count" per "WO#" for that month. 

 

Does anyone have any ideas on how to easily do this in PowerBI? I could easy do this in PivotTable, but I want this to be automated. The goal would be to answer the following questions.

 

1. How many unique WO#s were there for a given year/month

2. For a given year/month, what was the average Part Number count per WO#?

 

Ultimately we want to track " Average Part Numbner Count per WO#" and see it go down month over month.

 

Hopefully this makes sense!

 

Thanks!

1 ACCEPTED SOLUTION
Anonymous
Not applicable

@v-yanjiang-msft 

 

I appreciate the help. I don't think I explained myself fully, but after looking at what you did in your example, I realized I was over thinking the whole thing, was making it more difficult than it needed to be and was able to solve it using just a couple measures and some math. 

 

Thanks for getting me to think differently!

View solution in original post

2 REPLIES 2
v-yanjiang-msft
Community Support
Community Support

Hi @Anonymous ,

According to your description, I create a sample. 

vkalyjmsft_0-1657615939087.png

Maybe I didn't fully understand. When we put the year and month in the slicer, the measures created can dynamically change by the slicer.

 

WO# Count = DISTINCTCOUNT('Table'[WO#])
Average Part Number = AVERAGE('Table'[Part Number])

 

vkalyjmsft_1-1657616620211.png

If the problem is not like this, please feel free to let me know.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please considerAccept it as the solution to help the other members find it more quickly.

Anonymous
Not applicable

@v-yanjiang-msft 

 

I appreciate the help. I don't think I explained myself fully, but after looking at what you did in your example, I realized I was over thinking the whole thing, was making it more difficult than it needed to be and was able to solve it using just a couple measures and some math. 

 

Thanks for getting me to think differently!

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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