Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper III
Helper III

Help Neede (Urgent)

dim_service to dim_route_stage (1 to many via service_key column).  dim_service to agg_route( 1 to many via service_key column). agg_route to agg_route_trip ( 1 to many via Pk column).  agg_route_trip to agg_route_stop ( 1 to many via Trip_stop column).


Now I created a table visual contains cloumns--> service column (dim_service table), stage_seq_no, stage_name columns ( dim_route_stage table), boarding column (agg_route_trip/agg_route_stop table), Epk column (agg_route_trip table) .


I am getting the following output which is wrong. boarding & EPK should be different for each stage_name. Please help me to get the required output.




Sample File Link: 


Pbix File Link: 



Super User
Super User

Hi @Chandramouli_BI 

Please create a pbix file with mentioned sample data and share the pbix file Google drive link with All Access

Hi @PijushRoy Now I have added sample file & Pbix file in the query. Pls resolve this issue. Thanks

Helpful resources

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.


Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.


Fabric certifications survey

Certification feedback opportunity for the community.