Forum Discussion
Assigning Values based on conditions
hi Ttaylor9870
try to plot a table visual with Name column and two measures like:
AmountSum = SUM(TableName[Amount]) MaxDeliveryDate = MINX( FILTER( TableName, TableName[Amount]=MAX(TableName[Amount]) ), TableName[Delivery Day] )it worked like:
Hi FreemanZ,
How would this then look if you were to change it to No of rows opposed to Amount?
Name Amount Delivery Day A 1 Blank A 2 Day 1 A 1 Day 1 A 5 Day 2 B 4 Day5 B 5 Blank B 8 Day 2 B 12 Day2 C 7 Day 3 C 8 Day 1 C 17 Day5 C 1 Day 1 Company Amount Delivery Day A 9 Day 1 B 29 Day 2 C 33 Day 1
hi Ttaylor9870
can you describe the calculation behind?
Hi FreemanZ ,
There was no calculated columns or measures to create the columns that's they way they naturally sit.
I'd like the amounts added up and then whatever Delivery day had more than 50% of the total then assign delivery date to that.
hi Ttaylor9870
how do you come with 6, 15, 24?
Apologies! My bad I've edited the post and forgot to edit my expected table here is it fixed...
My Table...
Name Amount Delivery Day A 1 Blank A 2 Day 1 A 1 Day 1 A 5 Day 2 B 4 Day5 B 5 Blank B 12 Day2 C 7 Day 3 C 8 Day 1 C 17 Day5 Expected result...
Name Amount Delivery Date A 9 Day 2 B 21 Day 2 C 32 Day 5 hi Ttaylor9870
try to plot a table visual with Name column and two measures like:
AmountSum = SUM(TableName[Amount]) MaxDeliveryDate = MINX( FILTER( TableName, TableName[Amount]=MAX(TableName[Amount]) ), TableName[Delivery Day] )it worked like: