Forum Discussion
Matrix calculation Issue - DAX
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.
Leave_Hours =
CALCULATE (
SUM ( vw_Timely_Ehub_EA_Work_Flow_Tracker_Data_User[Time_In_Hr] ),
REMOVEFILTERS (
vw_Timely_Ehub_EA_Work_Flow_Tracker_Data_User[SponsorName],
vw_Timely_Ehub_EA_Work_Flow_Tracker_Data_User[SponsorArea],
vw_Timely_Ehub_EA_Work_Flow_Tracker_Data_User[SponsorRegion],
vw_Timely_Ehub_EA_Work_Flow_Tracker_Data_User[SponsorCountry]
),
ALLSELECTED ( vw_Timely_Ehub_EA_Work_Flow_Tracker_Data_User[Requestor] ),
KEEPFILTERS ( vw_Timely_Ehub_EA_Work_Flow_Tracker_Data_User[Leave_Type]
IN { "Holiday", "LeaveType" } )
)
Hi GaloyanTelman ,
This one was giving correct billable utilization values..
But was showing all the requestor names irrespective of the resource name.. Like requestors of other resources are also displaying in the matrix visual.