topic Re: Need DAX formulas in DAX Commands and Tips

Need DAX formulas

PB_QNB — Tue, 23 Apr 2024 07:01:08 GMT

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

Re: Need DAX formulas

Anonymous — Wed, 24 Apr 2024 02:59:11 GMT

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.

Re: Need DAX formulas

PB_QNB — Wed, 24 Apr 2024 04:41:52 GMT

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.

Re: Need DAX formulas

PB_QNB — Wed, 24 Apr 2024 04:44:43 GMT

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

Re: Need DAX formulas

PB_QNB — Tue, 30 Apr 2024 04:59:58 GMT

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.

Re: Need DAX formulas

PB_QNB — Fri, 24 May 2024 08:38:19 GMT

Hi Yulia,

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