Forum Discussion

WinterGarden's avatar
WinterGarden
Resolver I
7 months ago
Solved

Matrix calculation Issue - DAX

Hi All, I have a matrix visual similar to below table, where i have to show "Billable_Utilization"(2nd Column) Billable_Utilization = (Billable_Hours / (Standard_Hr1 - Leave_Hours))*100 As per...
Need Help
  • WinterGarden's avatar
    WinterGarden
    7 months ago

    krishnakanth240 ,
    Hi ,
    This is giving correct billable utilization values, but  the problem is that other resources sponsors are also showing(The rows were Time_in_Hr and Billable_Utl columns are blank) since we removed the filters on the requestors.. 

    Also the Non Billable_Utl should be blank for all requestors except Requestor = "Non- Billable" (it is showing 18.04% for all requestors..)


    if i apply Time_In_Hr = is not blank on the filter pane of this matrix visual it will work.. But this Leave_Hour measure is causing issue in my another table viusual.. where all requestors are showing irrespective of the resource name..

    So i created a duplicate of the table( vw_Timely_Ehub_EA_Work_Flow_Tracker_Data_User) where i filtered only the non billable rows(Billable column = Non-Billable) .. and updated the measures accordingly.. and it is working fine..

    Thank you so much for all the suggestions 🙂 I really appreciate it.



WinterGarden's avatar
WinterGarden
Resolver I
7 months ago

Hi krishnakanth240 ,

a) vw_EHub_Fiscal_Calendar_Headcount_Tracker_Data : stdd_hr is same for all the resource.. 40 hrs per week

b) (SponsorName, SponsorArea, SponsorRegion, SponsorCountry):
AJT, APAC, OCEANIA, Australia - for all rows

krishnakanth240's avatar
krishnakanth240
Super User
7 months ago

Hi WinterGarden 

 

Thanks for sharing!

 

Want to clarify from which table these columns are coming from 

RequestorBillable_Utilization - As per my calculationBillable_Hours  Standard_Hr1  Leave_Hours

 

It's confusing actually. Can you give all the list of table names along with the columns and 30 sample records for it to work on DAX. Thank You!