Blog Post

Power BI Community Blog
8 MIN READ

Think inside the box - Custom visuals using Standard Visuals

MFelix's avatar
MFelix
Super User
7 years ago
The context Looking at the evolution of Power BI during the last three and a half years, one thing that really is visible is the number of custom visuals and the variety of solutions that they let ...
Updated 7 years ago
Version 4.0
Custom visual
DAX
Measures
MFelix's avatar
Super User
Joined September 19, 2016
View Profile
Power BI Community Blog
On this blog you will find articles, guides and information created by our community members and, from time to time, roundups and community news. If you are interested in becoming a community blog author, send a private message to Natalie_iTalent. An overview of the community blogs can be found here.
MFelix's avatar
MFelix
Super User
5 years ago

Hi rsbin 

 

In this case you need to use the following measure:

Train Time = 
IF (
    (
        MAX ( DIM_Time_Matrix[ClockTime_HHMM] ) >= MAX ( TrainStatistics[Departure] )
           || MAX ( DIM_Time_Matrix[ClockTime_HHMM]) <= MAX ( TrainStatistics[ReleaseRounded] )
    ),
    
    1
)

 

Final result below:

Check this wetransfer link with the file.