Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
PB_QNB
Regular Visitor

Need DAX formulas

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

5 REPLIES 5
PB_QNB
Regular Visitor

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
Regular Visitor

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.

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

v-xuxinyi-msft
Community Support
Community Support

Hi @PB_QNB 

 

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

 

My sample:

vxuxinyimsft_0-1713927117608.png

 

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:

vxuxinyimsft_1-1713927258807.png

 

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.

20240524_113444.jpg

 Hi Yulia,

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

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.