Need DAX formulas

[PB_QNB]

I have User TAT, Application Numbers, Application Type. I need DAX formulas 1) Total TAT per distinct Application Number, and 2) Total TAT for Application Number AND distinct User TAT

[PB_QNB]

Hi Yulia, 

Thanks again, but I'm not looking for counts. I need to sum the TAT for Applications....I having multiple records of TAT which has to be be added only once. In other language the query is: q1 Total (Distinct([User TAT]) for Application Number)

Q2 Total(Distinct [User TAT] for [Application Numbers], [Application Type])

By the way, my visual takes care of this and I crossed checked by taking my data into Excel and creating a pivot table. But I still need to understand how to get the DAX to do the column calculations. Thanks for you help. 

[PB_QNB]

Thanks for your reply Yulia. I'm looking to sum up the TAT for applications. There are duplications I need to keep so I'm trying to sum the distibct TAT per distinct application.

[PB_QNB]

And secondly, for each application there are different types of application ....like Acco12345, type is DeptAODImplementor.....Acco12345, DepITReviewer. Each has duplications.

[v-xuxinyi-msft]

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.

[PB_QNB]

 Hi Yulia,

Sorry for late reply. I hope you can see the photo....I need the DAX to calculate columns F and G