Forum Discussion

WinterGarden's avatar
WinterGarden
Resolver I
6 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
    6 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.



krishnakanth240's avatar
krishnakanth240
Super User
6 months ago

Hi WinterGarden 

Thanks for sharing for one table.

Could you please share these inputs.

a)Some more data of records for these columns(Fiscal Week, Resource, stdd_hr) for 'Table' - vw_EHub_Fiscal_Calendar_Headcount_Tracker_Data

 

b)Sample data of rows for these columns(SponsorName, SponsorArea, SponsorRegion, SponsorCountry) with records for the above 'Table' you shared - vw_Timely_Ehub_EA_Work_Flow_Tracker_Data_User

WinterGarden's avatar
WinterGarden
Resolver I
6 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