Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have the following table
Aspect | Type | Software |
1.1 | A | XX |
1.2 | A | XX |
1.3 | A | XX |
1.4 | A | XX |
1.4 | A | XX |
1.1 | A | XX |
1.2 | B | ZZ |
1.2 | A | ZZ |
1.2 | A | ZZ |
2.1 | A | XX |
2.2 | A | ZZ |
2.3 | A | YY |
2.2 | A | XX |
2.1 | B | YY |
2.3 | A | YY |
1.1 | A | XX |
1.4 | A | YY |
2.2 | A | YY |
2.3 | C | XX |
1.3 | A | YY |
and I would like to filter this table with a measure, the filter can not be a page level filter. the filter must only show Type A.
then I should group every Aspect and count the amount for each Software. So the measure should throw a table somthing like this
Aspect | XX | YY | ZZ |
1.1 | 3 | ||
1.2 | 1 | 2 | |
1.3 | 1 | 1 | |
1.4 | 2 | 1 | |
2.1 | 1 | ||
2.2 | 1 | 1 | 1 |
2.3 | 2 | ||
Total | 9 | 5 | 3 |
Then I want to create a cake graph with 4 parameters (Yellow, Orange, Green and Blue) were the amount for each parameter have this following rule
Thanks
Solved! Go to Solution.
You may create measures to get the visual. Please refer to the attached sample file.
Regards,
Cherie
You may create measures to get the visual. Please refer to the attached sample file.
Regards,
Cherie
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |