Forum Discussion
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
1 Reply
- lbendlinSuper User
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523