Forum Discussion

TimBriggs's avatar
TimBriggs
New Member
8 months ago
Solved

Table Column to Calculate Totals

Hi all,    I want to add a column to the table below which show the % of Total QR's done without an NC found? So in this example, 3 total QRs complete. 1 NC found would be 66.66% correct.  ...
Need Help
Tutorial Requests
  • cengizhanarslan's avatar
    cengizhanarslan
    8 months ago

    Please try the measure below:

    % QRs Without NC =
DIVIDE (
    [Total QRs] - [NCs Found],
    [Total QRs]
)
pankajnamekar25's avatar
pankajnamekar25
Icon for Super User rankSuper User
8 months ago

Hello TimBriggs 

 

try this

Create Total QRs measure
Total QRs =
COUNTROWS ( 'TableName' )

Create NC Found measure

(Adjust condition based on how NC is stored)

NC Found =
CALCULATE (
COUNTROWS ( 'TableName' ),
'TableName'[NC_Found] = "Yes"
)

% of QRs without NC (Final Answer)
% QRs Without NC =
VAR TotalQR = [Total QRs]
VAR NCCount = [NC Found]
RETURN
DIVIDE ( TotalQR - NCCount, TotalQR )

 


If my response helped you, please consider clicking
Accept as Solution ✅ and giving it a Like 👍 – it helps others in the community too.


Thanks,


Connect with me on:

LinkedIn