Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have a DB table which has data as the following:
Please help on the below task asap.
Input Data | Output Data | |||||
Area | Element | Result | ||||
H.0100 | H.0100.01.01.01 | Area | Element | Required Result | ||
H.0100 | H.0100.01.01.01 | H.0100 | H.0100.01.01.01 | 4 | ||
H.0100 | H.0100.01.01.01 | H.0100 | H.0100.01.01.02 | 2 | ||
H.0100 | H.0100.01.01.01 | H.0130 | H.0130.01.03 | 3 | ||
H.0100 | H.0100.01.01.02 | H.0130 | H.0130.04.01 | 5 | ||
H.0100 | H.0100.01.01.02 | |||||
H.0130 | H.0130.01.03 | |||||
H.0130 | H.0130.01.03 | |||||
H.0130 | H.0130.01.03 | |||||
H.0130 | H.0130.04.01 | |||||
H.0130 | H.0130.04.01 | |||||
H.0130 | H.0130.04.01 | |||||
H.0130 | H.0130.04.01 | |||||
H.0130 | H.0130.04.01 |
Thank a Lot!!!
Solved! Go to Solution.
Hi @reddeppag,
In the second suggestion posted by @v-yulgu-msft, the function should be COUNTA().
Hi @reddeppag,
Two ways for your reference.
1. Create a calculated table like below.
Output = SUMMARIZE ( Input, Input[Area], Input[Element], "Count value", COUNT ( Input[Element] ) )
2. Based on your Input table, create a measure.
Required result = COUNT(Input[Element])
Then, in report view, insert a table visual, directly add above measure into visual.
Best regards,
Yuliana Gu
User | Count |
---|---|
78 | |
75 | |
62 | |
60 | |
47 |
User | Count |
---|---|
109 | |
95 | |
86 | |
79 | |
61 |