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.



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



v-achippa's avatar
v-achippa
Community Support
6 months ago

Hi WinterGarden,

 

Thank you krishnakanth240 and GaloyanTelman for the prompt response. 

 

Thank you for confirming that the issue is resolved now. Thank you for being part of Microsoft Fabric Community.

 

Thanks and regards,

Anjan Kumar Chippa