Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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       67      SEA      34      45      STO
 55       76         TRUCK   55       97      SEA      44      55      STO

 45       66         TRUCK   25       27      SEA      22      88      STO

if i select truck filter i want show only  truck values only trucksp and truckquty divide value . value should be show based on the filter selection .  

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    Anonymous , 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"))

    )