% of Total only on Lowest Drillable Data

[dbro23]

Hi,

I need to have my lowest drillable rows be a % of the total of the second level.

Level 1: Warehouse

Level 2: Machine (Asset)

Level 3: Product

For context, I'm trying to figure out the total % of GT of products being created per machine (asset), but I want the machine utilized % to show me the total % utilization (Forecast Qty/Planned Capacity), and each Warehouse to show me the average utilization per machine through the entire warehouse.

In this example, Warehouse and Machine are correct, but Product 1 should say 100% (Since it is the only product being made by this machine). If there were multiple products being made in one machine, product 1 would need to show the weight %GT.

I feel like my formula is close, but if you can figure this out another way, please feel free!

[v-rzhou-msft]

Hi @dbro23 ,

Due to I don't know your data model, here I will give you some suggestions.

According to your statement, I think your requirement is to show different calculation logic in different hierarchy levels.

I suggest you to try ISINSCOPE function (DAX) .

For reference: Use IsInScope to get the right hierarchy level in DAX - Kasper On BI

If this reply still couldn't help you solve your issue please share a sample file with me and show me the result you want. This will make it easier for me to find the solution.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.