Forum Discussion
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.
Can anyone provide me with help?
Thank you
Please try the measure below:
% QRs Without NC = DIVIDE ( [Total QRs] - [NCs Found], [Total QRs] )
6 Replies
- cengizhanarslan
Super User
Please try the measure below:
% QRs Without NC = DIVIDE ( [Total QRs] - [NCs Found], [Total QRs] )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
- 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 🌀.
- 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 - 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)
