Forum Discussion

yoyfreddy's avatar
yoyfreddy
Frequent Visitor
4 years ago
Solved

Visual with multiple filter not working

Hello experts!   I have a table containing the Unit Cost of different Cost Category of different Airlines; and another table with the Cost Driver of different Cost Category of different Airlines. I...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    4 years ago

    Hi yoyfreddy ,

     

    Create a new column in Cost table:

    Driver = RELATED(Classification[Cost Driver])

    Create a new measure like below:

    Measure = 
var unit_cost = MAX(Cost[Unit Cost])
var airline_ = MAX(Cost[Airline])
var driver_ = MAX(Cost[Driver])
var sum_opstat = CALCULATE(SUM(OpStat[Value]),FILTER(OpStat,OpStat[Airline]=airline_&&OpStat[Cost Driver]=driver_))
return MAX(Cost[Unit Cost])*sum_opstat

     

     

    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

V-lianl-msft's avatar
V-lianl-msft
Community Support
4 years ago

Hi yoyfreddy ,

 

Create a new column in Cost table:

Driver = RELATED(Classification[Cost Driver])

Create a new measure like below:

Measure = 
var unit_cost = MAX(Cost[Unit Cost])
var airline_ = MAX(Cost[Airline])
var driver_ = MAX(Cost[Driver])
var sum_opstat = CALCULATE(SUM(OpStat[Value]),FILTER(OpStat,OpStat[Airline]=airline_&&OpStat[Cost Driver]=driver_))
return MAX(Cost[Unit Cost])*sum_opstat

 

 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

yoyfreddy's avatar
yoyfreddy
Frequent Visitor
4 years ago

Thank you Liang for your help. Your file also solved my Date problem too!