Forum Discussion
PB_QNB
2 years agoRegular 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
PB_QNB
2 years agoRegular 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.