Forum Discussion
Power filter value based on the filter selection
I have different shipment data single sheet like below screen shot for reference Trucksp Truckquty Filter Seasp Seaquty Filter STOsp STOquty Filter
45 66 TRUCK 55 ...
amitchandak
Super User
Super UserAnonymous , As these, are three columns, you need an independent column to get three value and create value like
New measure = Switch(selectedvalue(filter([Filter]),
"Truck" , calculate(divide(sum(Table[Trucksp]), Sum(Table[TruckQty])), filter(Table, Tabke[Filter] ="Truck"))
"Sea" , calculate(divide(sum(Table[Seasp]), Sum(Table[SeaQty])), filter(Table, Tabke[Filter2] ="SEA"))
)