Table Column to Calculate Totals

[TimBriggs]

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.

Can anyone provide me with help?

Thank you

[cengizhanarslan · Accepted solution]

Please try the measure below:

% QRs Without NC =
DIVIDE (
    [Total QRs] - [NCs Found],
    [Total QRs]
)

[TimBriggs]

Hi thank you, Managed to get it looking like the below, but cannot seem to get it as a %

[cengizhanarslan]

• Select the measure in the Fields pane

• Measure tools → Format = Percentage

• Set decimals

[krishnakanth240]

Hi @TimBriggs 

Can you please check this measure

% QR Without NC =
VAR TotalQR = SUM('YourTable'[Total QR's])
VAR NCFound = SUM('YourTable'[NC's Found])
RETURN
DIVIDE(TotalQR - NCFound, TotalQR, 0)

[pankajnamekar25]

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

[Zanqueta]

Hi @TimBriggs ,

f you are just starting out with DAX in Power BI, I recommend using Quick Measures to accomplish this.
Please follow the steps below, and let me know if you need any additional assistance.

If this response was helpful in any way, I’d gladly accept a 👍much like the joy of seeing a DAX measure work first time without needing another FILTER.

Please mark it as the correct solution. It helps other community members find their way faster (and saves them from another endless loop 🌀.