Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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