I have a dimension which categorizes labor as direct and indirect now I have a measure [indirect hours] which comes only for indirect employees and others remain blank. and another measure [direct hours] which comes only for direct employees and others remain blank.
I want to create a calculated measure [indirect hours]/[direct hours] and show it in front of all direct employees.
Currently it is showing all blank there. Any help would be much appreciated