Forum Discussion
Summary Table, Unique Counts, Graphs and Averages - How to incorporate them all?
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!
Community SupportHi Anonymous ,
According to your description, I create a sample.
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])
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.
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!