Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Not get the correct percentage on graph

I am getting problem to get the percentage as per the filter 

i created a graph with help of measure, 

 

Trend_ICR = DIVIDE(COUNTAX(FILTER('Pillar_Rating Trending','Pillar_Rating Trending'[Rating]="ICR""),'Pillar_Rating Trending'[Rating]),CALCULATE(COUNTA('Pillar_Rating Trending'[Week]),ALLSELECTED('Pillar_Rating Trending'[Week)))) getting 100% of every bar after use this measure.  below is screen shot is correct result which i wanted. Please help me out.

 

this is the correct result which i wantthis is the correct result which i want

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Trend_ICR = DIVIDE(COUNTAX(FILTER('Pillar_Rating Trending','Pillar_Rating Trending'[Rating]="ICR""),'Pillar_Rating Trending'[Rating]),CALCULATE(COUNTA('Pillar_Rating Trending'[Week]),ALLSELECTED('Pillar_Rating Trending'[Week)))) getting 100% of every bar after use this measure. 

 

 

5 REPLIES 5
Anonymous
Not applicable

SN.Week YTDMonthAttributeRating
1Week 21MaySection 2PD
2Week 21MaySection 2PD
3Week 21MaySection 2PD
4Week 21MaySection 2PD
5Week 21MaySection 2PD
6Week 21MaySection 2PD
7Week 21MaySection 2PD
8Week 21MaySection 2PD
9Week 21MaySection 2PD
10Week 21MaySection 2PD
11Week 21MaySection 2PD
12Week 21MaySection 2PD
13Week 21MaySection 2PD
14Week 21MaySection 2PD
15Week 21MaySection 2PD
16Week 21MaySection 2PD
17Week 21MaySection 2PD
18Week 21MaySection 2PD
19Week 21MaySection 2PD
20Week 21MaySection 4PD
21Week 21MaySection 4PD
22Week 21MaySection 4PD
23Week 21MaySection 4PD
24Week 21MaySection 4PD
25Week 21MaySection 4PD
26Week 21MaySection 4PD
27Week 21MaySection 4PD
28Week 21MaySection 4PD
29Week 21MaySection 4PD
30Week 20MaySection 5PD
31Week 20MaySection 6PD
32Week 20MaySection 5PD
33Week 20MaySection 7PD
34Week 20MaySection 5PD
35Week 20MaySection 5PD
36Week 20MaySection 6PD
37Week 20MaySection 6PD
38Week 20MaySection 7PD
39Week 20MaySection 5PD
40Week 20MaySection 7PD
41Week 20MaySection 7PD
42Week 20MaySection 5PD
43Week 20MaySection 7PD
44Week 20MaySection 7PD
45Week 20MaySection 6PD
46Week 20MaySection 5PD
47Week 20MaySection 5PD
48Week 20MaySection 6PD
49Week 20MaySection 5PD
50Week 20MaySection 7PD
51Week 20MaySection 6PD
52Week 20MaySection 6PD
53Week 20MaySection 6PD
54Week 20MaySection 5PD
55Week 20MaySection 6PD
56Week 20MaySection 5PD
57Week 20MaySection 6PD
58Week 20MaySection 5PD
59Week 20MaySection 6PD
60Week 20MaySection 5PD
61Week 20MaySection 5PD
62Week 20MaySection 7PD
63Week 20MaySection 5PD
64Week 20MaySection 7PD
65Week 20MaySection 6PD
66Week 20MaySection 5PD
67Week 20MaySection 6PD
68Week 20MaySection 5PD
69Week 20MaySection 6PD
70Week 20MaySection 5PD
71Week 20MaySection 6PD
72Week 20MaySection 6PD
73Week 20MaySection 5PD
74Week 20MaySection 5PD
75Week 20MaySection 6PD
76Week 20MaySection 5PD
77Week 20MaySection 6PD
78Week 20MaySection 5PD
79Week 20MaySection 6PD
80Week 20MaySection 4PD
81Week 20MaySection 4PD
82Week 20MaySection 4PD
83Week 20MaySection 4PD
84Week 20MaySection 4PD
85Week 20MaySection 4PD
86Week 20MaySection 4PD
87Week 20MaySection 4PD
88Week 20MaySection 4PD
89Week 20MaySection 4PD
90Week 20MaySection 4PD
91Week 20MaySection 4PD
92Week 20MaySection 4PD
93Week 20MaySection 4PD
94Week 20MaySection 4PD
95Week 20MaySection 4PD
96Week 20MaySection 4PD
97Week 20MaySection 4PD
98Week 20MaySection 4PD
99Week 20MaySection 4PD
100Week 20MaySection 4PD
101Week 20MaySection 4PD
102Week 20MaySection 4PD
103Week 20MaySection 4PD
104Week 20MaySection 4PD
105Week 20MaySection 4PD
106Week 20MaySection 4PD
107Week 20MaySection 4PD
108Week 20MaySection 4PD
109Week 20MaySection 4PD
110Week 20MaySection 4PD
111Week 20MaySection 4PD
112Week 20MaySection 4PD
113Week 20MaySection 4PD
114Week 20MaySection 4PD
115Week 20MaySection 4PD
116Week 20MaySection 4PD
117Week 20MaySection 4PD

Actually i want percentage on graph as per the filter. 

i want graph with % like this

 

Test.jpg

 I created the measure to get the % (

DIVIDE(COUNTAX(FILTER('Pillar_Rating Trending','Pillar_Rating Trending'[Rating]="Immediate Coaching Required"),'Pillar_Rating Trending'[Rating]),CALCULATE(COUNTA('Pillar_Rating Trending'[Week YTD]),ALLSELECTED('Pillar_Rating Trending'[Week YTD])))). Now problem is when i change the below drop down which is showing on the screen shot then will get the below result 100% in every bar. Please help me out.

screen shot.png

dax
Community Support
Community Support

Hi,

 

I am not clear about your logic, why the percentage's total for week will over 100%? If possible, could you please inform me the detailed sample data.

If your data sample like below

SN.Week YTDMonthAttributeRating

1Week 20MaySection 2PD
2Week 20MaySection 2PD
3Week 20MaySection 2PD
4Week 21MaySection 2PD
5Week 21MaySection 2PD
6Week 20MaySection 2PD1
7Week 21MaySection 2PD1
8Week 21MaySection 2PD1
9Week 21MaySection 2PD
10Week 21MaySection 2PD
11Week 21MaySection 2PD
12Week 21MaySection 2PD
13Week 21MaySection 2PD
14Week 21MaySection 2PD
15Week 21MaySection 2PD
16Week 21MaySection 2PD
17Week 21MaySection 2PD
18Week 21MaySection 2PD
19Week 21MaySection 2PD
20Week 21MaySection 4PD
21Week 20MaySection 4PD1
22Week 20MaySection 4PD1
23Week 21MaySection 4PD1
24Week 21MaySection 4PD1
25Week 21MaySection 4PD1
26Week 21MaySection 4PD1
27Week 21MaySection 4PD1
28Week 21MaySection 4PD
29Week 21MaySection 4PD
30Week 20MaySection 5PD
31Week 20MaySection 6PD
32Week 21MaySection 5PD
33Week 20MaySection 7PD
34Week 21MaySection 5PD
35Week 20MaySection 5PD
36Week 20MaySection 6PD
37Week 20MaySection 6PD
38Week 20MaySection 7PD
39Week 20MaySection 5PD1
40Week 21MaySection 7PD
41Week 21MaySection 7PD
42Week 20MaySection 5PD
43Week 21MaySection 7PD
44Week 20MaySection 7PD
45Week 21MaySection 6PD
46Week 20MaySection 5PD1
47Week 20MaySection 5PD1
48Week 20MaySection 6PD
49Week 20MaySection 5PD
50Week 20MaySection 7PD1
51Week 20MaySection 6PD
52Week 20MaySection 6PD
53Week 20MaySection 6PD1
54Week 20MaySection 5PD
55Week 20MaySection 6PD
56Week 20MaySection 5PD
57Week 21MaySection 6PD
58Week 20MaySection 5PD
59Week 21MaySection 6PD
60Week 20MaySection 5PD
61Week 20MaySection 5PD
62Week 20MaySection 7PD
63Week 20MaySection 5PD
64Week 20MaySection 7PD1
65Week 20MaySection 6PD
66Week 20MaySection 5PD1
67Week 20MaySection 6PD1
68Week 20MaySection 5PD1
69Week 20MaySection 6PD1
70Week 20MaySection 5PD1
71Week 21MaySection 6PD
72Week 21MaySection 6PD
73Week 20MaySection 5PD
74Week 20MaySection 5PD
75Week 20MaySection 6PD
76Week 20MaySection 5PD
77Week 20MaySection 6PD
78Week 20MaySection 5PD
79Week 20MaySection 6PD
80Week 20MaySection 4PD
81Week 20MaySection 4PD
82Week 20MaySection 4PD
83Week 20MaySection 4PD
84Week 20MaySection 4PD
85Week 21MaySection 4PD
86Week 21MaySection 4PD
87Week 21MaySection 4PD
88Week 21MaySection 4PD
89Week 21MaySection 4PD
90Week 21MaySection 4PD
91Week 21MaySection 4PD
92Week 20MaySection 4PD
93Week 20MaySection 4PD
94Week 20MaySection 4PD
95Week 20MaySection 4PD
96Week 20MaySection 4PD
97Week 20MaySection 4PD
98Week 20MaySection 4PD
99Week 20MaySection 4PD
100Week 20MaySection 4PD
101Week 20MaySection 4PD
102Week 20MaySection 4PD
103Week 20MaySection 4PD
104Week 20MaySection 4PD
105Week 20MaySection 4PD
106Week 20MaySection 4PD
107Week 20MaySection 4PD
108Week 20MaySection 4PD
109Week 20MaySection 4PD
110Week 20MaySection 4PD
111Week 20MaySection 4PD
112Week 20MaySection 4PD
113Week 20MaySection 4PD
114Week 20MaySection 4PD
115Week 20MaySection 4PD
116Week 20MaySection 4PD
117Week 20MaySection 4PD

 Then you could try below measure

Measure 8 =
DIVIDE (
    COUNTX ( 'Pillar_Rating Trending', 'Pillar_Rating Trending'[Week YTD] ),
    CALCULATE (
        COUNT ( 'Pillar_Rating Trending'[Attribute] ),
        ALLEXCEPT (
            'Pillar_Rating Trending',
            'Pillar_Rating Trending'[Rating],
            'Pillar_Rating Trending'[Attribute]
        )
    )
)

100.PNG

Best Regards,

Zoe Zhi

 

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

Anonymous
Not applicable

Hi,

I want my table like below, when i change the Rating from CR to PD or ICR then percetnage would change and 

 WeekRatingk
  CR
AttributeWeek 22Week 23
Section 10%0%
Section 240%33%
Section 356%43%
Section 428%27%
Section 535%0%
Section 620%0%
Section Offline 744%31%
Anonymous
Not applicable

Hi,

This is RD

Week YTDAttributeRating
Week 22Section 1PD
Week 22Section 1PD
Week 22Section 1PD
Week 22Section 1PD
Week 22Section 6PD
Week 22Section 1PD
Week 22Section 4PD
Week 22Section 6PD
Week 22Section 4PD
Week 22Section 4PD
Week 22Section 1PD
Week 22Section 4PD
Week 22Section 4PD
Week 22Section 4PD
Week 22Section 4PD
Week 22Section 6PD
Week 22Section 6PD
Week 22Section 5PD
Week 22Section 5PD
Week 22Section 5PD
Week 22Section 5PD
Week 22Section 3PD
Week 22Section 3PD
Week 22Section 3PD
Week 22Section 3PD
Week 24Section 4PD
Week 24Section 6PD
Week 24Section 6PD
Week 24Section 4PD
Week 24Section 6PD
Week 24Section 6PD
Week 24Section 4PD
Week 24Section 6PD
Week 24Section 6PD
Week 24Section 4PD
Week 24Section 6PD
Week 24Section 4PD
Week 24Section 6PD
Week 24Section 4PD
Week 24Section 4PD
Week 24Section 6PD
Week 24Section 4PD
Week 24Section 6PD
Week 24Section 4PD
Week 24Section 6PD
Week 24Section 4PD
Week 24Section 6PD
Week 24Section 4PD
Week 24Section 6PD
Week 24Section 4PD
Week 24Section 5PD
Week 24Section 4PD
Week 24Section 6PD
Week 24Section 4PD
Week 24Section 5PD
Week 24Section 4PD
Week 24Section 6PD
Week 24Section 4PD
Week 24Section 4PD
Week 24Section 4PD
Week 24Section 4PD
Week 24Section 4PD
Week 24Section 4PD
Week 24Section 6PD
Week 24Section 6PD
Week 24Section 6PD
Week 24Section 6PD
Week 24Section 6PD
Week 24Section 4PD
Week 24Section 4PD
Week 24Section 6PD
Week 24Section 4PD
Week 24Section 5PD
Week 24Section 6PD
Week 24Section 5PD
Week 24Section 6PD
Week 24Section 4PD
Week 24Section 6PD
Week 24Section 4PD
Week 24Section 6PD
Week 24Section 4PD
Week 24Section 6PD
Week 24Section 4PD
Week 24Section 5PD
Week 24Section 4PD
Week 24Section 5PD
Week 24Section 4PD
Week 24Section 4PD
Week 24Section 6PD
Week 24Section 4PD
Week 24Section 6PD
Week 24Section 4PD
Week 24Section 6PD
Week 24Section 4PD
Week 24Section 6PD
Week 24Section 6PD
Week 24Section 4PD
Week 24Section 6PD
Week 24Section 4PD
Week 24Section 6PD
Week 24Section 4PD
Week 24Section 4PD
Week 24Section 4PD
Week 24Section 5PD
Week 24Section 4PD
Week 24Section 5PD
Week 24Section 6PD
Week 24Section 4PD
Week 24Section 5PD
Week 24Section 6PD
Week 24Section 4PD
Week 24Section 5PD
Week 24Section 6PD
Week 24Section 4PD
Week 24Section 5PD
Week 24Section 6PD
Week 24Section 4PD
Week 24Section 6PD
Week 24Section 4PD
Week 24Section 6PD
Week 24Section 3PD
Week 24Section 4PD
Week 24Section 5PD
Week 24Section 6PD
Week 24Section 3PD
Week 24Section 4PD
Week 24Section 6PD
Week 24Section 3PD
Week 24Section 4PD
Week 24Section 6PD
Week 24Section 6PD
Week 24Section 5PD
Week 24Section 6PD
Week 24Section 4PD
Week 24Section 6PD
Week 24Section 4PD
Week 24Section 4PD
Week 24Section 4PD
Week 24Section 4PD
Week 24Section 4PD
Week 24Section 6PD
Week 24Section 1PD
Week 24Section Offline 7PD
Week 24Section 4PD
Week 24Section 5PD
Week 24Section 6PD
Week 24Section Offline 7PD
Week 24Section 4PD
Week 24Section 6PD
Week 24Section 3PD
Week 24Section 2PD
Week 24Section 2PD
Week 24Section 2PD
Week 24Section 2PD
Week 23Section 2PD
Week 23Section 2PD
Week 23Section 2PD
Week 23Section 2PD
Week 23Section 5PD
Week 23Section 5PD
Week 23Section 5PD
Week 23Section 5PD
Week 23Section 6PD
Week 23Section 6PD
Week 23Section 6PD
Week 23Section 6PD
Week 23Section 6PD
Week 23Section 6PD
Week 23Section 6PD
Week 23Section 6PD
Week 23Section 6PD
Week 23Section 6PD
Week 23Section 6PD
Week 23Section 5PD
Week 23Section 6PD
Week 23Section 6PD
Week 23Section 5PD
Week 23Section 6PD
Week 23Section 5PD
Week 23Section 6PD
Week 23Section 5PD
Week 23Section 6PD
Week 23Section 6PD
Week 23Section 5PD
Week 23Section 6PD
Week 23Section 4PD
Week 23Section 4PD
Week 23Section 4PD
Week 23Section 6PD
Week 23Section 4PD
Week 23Section 5PD
Week 23Section 6PD
Week 23Section 4PD
Week 23Section 5PD
Week 23Section 6PD
Week 23Section Offline 7PD
Week 23Section 4PD
Week 23Section 5PD
Week 23Section 6PD
Week 23Section Offline 7PD
Week 23Section 5PD
Week 23Section 6PD
Week 23Section 3PD
Week 23Section Offline 7PD
Week 23Section 3PD
Week 23Section Offline 7PD
Week 23Section 3PD
Week 23Section Offline 7PD
Week 23Section 3PD
Week 22Section 5PD
Week 22Section 5PD
Week 22Section 2PD
Week 22Section 2PD
Week 25Section 1PD
Week 25Section 2PD
Week 25Section Offline 7PD
Week 25Section 4PD
Week 25Section 5PD
Week 25Section 6PD
Week 22Section 3CR
Week 22Section 3CR
Week 22Section 3CR
Week 22Section 3CR
Week 22Section 3CR
Week 23Section 3CR
Week 23Section 3CR
Week 23Section 3CR
Week 24Section 3CR
Week 22Section 6CR
Week 22Section 6CR
Week 22Section 6CR
Week 24Section 6CR
Week 24Section 6CR
Week 24Section 6CR
Week 22Section 5CR
Week 22Section 5CR
Week 22Section 5CR
Week 22Section 5CR
Week 22Section 5CR
Week 22Section 5CR
Week 22Section 5CR
Week 24Section 5CR
Week 24Section 5CR
Week 22Section 2CR
Week 22Section 2CR
Week 22Section 2CR
Week 22Section 2CR
Week 23Section 2CR
Week 23Section 2CR
Week 24Section 2CR
Week 24Section 2CR
Week 24Section 2CR
Week 22Section Offline 7CR
Week 22Section Offline 7CR
Week 22Section Offline 7CR
Week 22Section Offline 7CR
Week 23Section Offline 7CR
Week 23Section Offline 7CR
Week 23Section Offline 7CR
Week 23Section Offline 7CR
Week 24Section Offline 7CR
Week 24Section Offline 7CR
Week 24Section Offline 7CR
Week 22Section 4CR
Week 22Section 4CR
Week 22Section 4CR
Week 22Section 4CR
Week 22Section 4CR
Week 23Section 4CR
Week 23Section 4CR
Week 23Section 4CR
Week 24Section 4CR
Week 24Section 4CR
Week 24Section 4CR
Week 24Section 4CR
Week 24Section 4CR
Week 24Section 4CR
Week 22Section Offline 7ICR
Week 22Section Offline 7ICR
Week 22Section Offline 7ICR
Week 22Section Offline 7ICR
Week 22Section Offline 7ICR
Week 23Section Offline 7ICR
Week 23Section Offline 7ICR
Week 23Section Offline 7ICR
Week 23Section Offline 7ICR
Week 22Section 1ICR
Week 22Section 1ICR
Week 23Section 1ICR
dax
Community Support
Community Support

Hi mukesh_chand_MK,

It seems that you didn’t upload your expecting output successfully, so if possible, could you please inform me more detailed information(such as your sample data ,your calculation logic and your expecting output)? Then I will help you correctly.

 

Best Regards,

Zoe Zhi

 

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.