Need DAX formulas

Hi PB_QNB 

I've created a sample to test and hope it can help you.

My sample:

Create two measures as follow

q1 = CALCULATE(COUNT('Table'[User TAT]), ALLEXCEPT('Table', 'Table'[Application Numbers]))

q2 = CALCULATE(COUNT('Table'[Application Numbers]), ALLEXCEPT('Table', 'Table'[User TAT]))

Result:

For more details about ALLEXCEPT function, you can read related document link:

ALLEXCEPT function (DAX) - DAX | Microsoft Learn

If I've misunderstood you, please provide detailed sample data and the results you are hoping for: How to provide sample data in the Power BI Forum - Microsoft Fabric Community . Or show it as a screenshot or pbix. Please remove any sensitive data in advance. If uploading pbix files please do not log into your account.

Best Regards,
Yulia Xu

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