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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Ashley1022
Frequent Visitor

%GT and Rank


Hi, 
I have a requirement of computing for the %GT Value based on Securities in the Base table below and display the Top 3 values. However, when the ranking   filter is applied, %GT Value recalculates based on the Top 3 selected value only (refer to 2nd table below).  Is there a way i can display the %GT values without considering the Top 3 filter (refer to Preferred Output table)?Thank you in advance.

 

 

Base table   
Security     Value    %GT Value 
C1               44         29.93% 
D1               33        22.45% 
B1                24        16.33% 
A1                23         15.65% 
D1               12         8.16% 
D2               11          7.48% 

   
Top 3: Visual filter applied   
Security Value      %GT Value      Rank
C1           44          43.56%              1
D1            33         32.67%              2
B1            24          23.76%             3

   
Preferred Output   
Security       Value      %GT Value     Rank
C1                  44              29.93%       1
B1                   24              22.45%       2
D1                   33             16.33%        3

1 ACCEPTED SOLUTION
Eric_Zhang
Employee
Employee

@Ashley1022

Instead of auto calculation, create a measure instead.

GT Value measure = SUM(yourTable[Value])/CALCULATE(sum(yourTable[Value]),ALL(yourTable))

 

Capture.PNG

View solution in original post

2 REPLIES 2
Eric_Zhang
Employee
Employee

@Ashley1022

Instead of auto calculation, create a measure instead.

GT Value measure = SUM(yourTable[Value])/CALCULATE(sum(yourTable[Value]),ALL(yourTable))

 

Capture.PNG

thank you.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.