Total number of unique / individual entries?

[Matt_Bee_23]

Hi. Hopefully this is a simple enough request for you guys. I've got a bunch of raw data that I'm trying to work out for a project at work. In the table below is an example piece of the data I'm working with,it's a lot bigger than this. The info I am wanting to get if it's possible, can I filter or create a graph showing the following:

• How many times each material number appears on the report.
• How many times each material number appears on the report & by site
• The first and last date a material appears on the report

There are a lot of other sites on the report, can it be possible to show the number of times a site appears on the report? Example, Birmingham in the below is on there 23 times and is showing 3 individual materials & 4 individual batches, can the report tell me how many times Birmingham appears, as well as showing the material each time? Hopefully nothing too complex to get, I'm a Power BI newbie. Thanks.

[v-xinruzhu-msft · Accepted solution]

Hi @Matt_Bee_23 

Do you want to achieve the following output

If the output is your requirement, you can refer to the following two measures.

Count_plants = CALCULATE(COUNTROWS('Table'),ALLEXCEPT('Table','Table'[Plant]))

Count_material_byplants = CALCULATE(COUNTA('Table'[Material]),ALLEXCEPT('Table','Table'[Plant],'Table'[Material]))

Best Regards!

Yolo Zhu

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

[Matt_Bee_23]

Plant	Material	Batch	Year	Month
Yorkshire	12233383	AAACCC	2023	1
Yorkshire	12233383	AAACCC	2022	2
Yorkshire	12233383	AAADDD	2023	2
Yorkshire	15566993	DDDFFF	2023	3
Birmingham	40092721	EEEVVV	2022	4
Birmingham	15566993	FFFCCC	2023	5
London	15566993	CCCCCC	2022	6
Birmingham	40092721	FFFGGG	2022	6
Birmingham	40092721	ZXXCCV	2023	7