Forum Discussion

aashok611's avatar
aashok611
Frequent Visitor
3 years ago

SPLIT WEIGHT

Hi ,

Pls refer to the below case where i need to get WT2 with DAX measure,

 

Note : 
For DIS = ST ,if CAT = L1, then for WT2 = (60% * WT1) else (WT1 / count of L2,L3,L4,,,N)
For DIS = ST ,if CAT = NA , then for WT2 = (WT1 / count of L2,L3,L4,,,N)
For DIS = EL ,if CAT = NA , then for WT2 = (WT1 / count of L2,L3,L4,,,N)

 

for CAT L1 alone 60% of WT1, rest of the case WT1/ ( number of CAT exclude L1 ie., count L2,L3,L4,,,,n)

 

Hope you can solve this, thanks in advance,

 

With regards,

Ashok A