Forum Discussion

TheKiltedGolfer's avatar
TheKiltedGolfer
Helper III
8 years ago

Calculated column using and/or within an If statement

I need assistance on how to do the following in Power BI.   Premise:  I have a query called Opened to Closed/Resolved (snapshot attached) that has the following columns: Ticket Number, Ticket State...
Need Help
TheKiltedGolfer's avatar
TheKiltedGolfer
Helper III
8 years ago

I am not sure if this makes sense to what I am trying to get but I did the following and got a result:

  1. Created new measures from the same field:  Distinct Closed, Distinct Open, Distinct Resolved, Distinct Tickets, Distinct Dates
  2. Created a new measure from a different field: Distinct Names
  3. Then created an additional new measure, in field from step 1, based on steps 1 & 2 called Tickets per Associate per Day with the formula: TicketsperAssocperDay = ([Distinct Tickets]/('Unpivot by Name Total Opened/Closed/Resolved Tickets'[Distinct Names])/[Distinct Dates])

Does what I did make any sense to discovering Tickets per Associate per Day? Leadership may want to see if this value increases, or reach a threshold, when considering hiring additional people.  Please let me know if this makes any sense or if there is a better way of doing this.  Very new to DAX and Power BI.

 

Thanks !!!