Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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:
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.
Solved! Go to 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.
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.
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 |
User | Count |
---|---|
93 | |
85 | |
78 | |
67 | |
63 |
User | Count |
---|---|
113 | |
99 | |
97 | |
64 | |
59 |