Forum Discussion

ScottA's avatar
ScottA
Frequent Visitor
5 years ago
Solved

Get results from dynamically calculated tables

Hi I’m having trouble doing this task dynamically in PowerBI.   My data table is a list of flights with information such as flight number, from/to, depart/arrive times.   Flights Flight Numb...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    ScottA , Try a measure like this to related arrival time with bucket

    calculate(countx(filter(Flights, Flights[arr time] >= Min(TimeBucket[from]) && Flights[arr time] <= max(TimeBucket[to])),[Flight Number]), values(flight[Flight Number]))

     

    You might need to copies time bucket to get this for departure time

ScottA's avatar
ScottA
Frequent Visitor
5 years ago

amitchandak 

 

Thank you, this pointed me in the right direction. I just made a small amendment to accomplish having it dynamic depending on filter selection of base table

 

Selected Base = SELECTEDVALUE(Base[Base])

 

Flights From =
VAR SelectedBase = [Selected Base]
VAR FilteredFlightsFrom =
    CALCULATETABLE ( Flights, Flights[Flight From] = SelectedBase )
RETURN
    CALCULATE (
        COUNTX (
            FILTER (
                FilteredFlightsFrom,
                Flights[dep time] >= MIN ( 'Time Bucket'[Time From] )
                    && Flights[dep time] <= MAX ( 'Time Bucket'[Time To] )
            ),
            Flights[Flight Number]
        ),
        VALUES ( Flights[Flight Number] )
    )

 

amitchandak's avatar
amitchandak
Super User
5 years ago

ScottA , hope it working for you. Kudos to you.