Power bi desktop function (representation)

Question

Hi, I've a Bi desktop problem that I can't fix. I've a table with the following columns: number of train,&nbsp;train maintenance facility,&nbsp;time of departure from station "x", time of arrival at station "y" and I would like to represent in a graph or in a table&nbsp;for each maintenance facility&nbsp;the total number of trains in operation at different times of the day.&nbsp;&nbsp;Thanks to anyone who can give me a hand

greg_deckler · Answer

Giuseppe_a97&nbsp;Take a look at these two Quick Measures as I think you want something like them.https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365
&nbsp;
If you post sample data can be more specific.

giuseppe_a97 · Answer

Greg_Deckler&nbsp;thanks for the answer, but I can't fix yet. I try to post a simple example:&nbsp;maintenance facility --- Departure hour --- Arrival hour --- trainMilano&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 07.00&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 12.00&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CA7183Roma&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 09.00&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 13.00&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; AX9283Napoli&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 14.00&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20.00&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; BY3273Milano&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 12.00&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;21.00&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CI8213Milano&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 12.30&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;14.00&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; AM1324Roma&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 18.00&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;19.00&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; OH1132&nbsp;Now the question is: how many trains of the Milan maintenance facility are in operation from 9 to 15?I would like to have a table/graph that show me this information&nbsp;Thanks&nbsp;&nbsp;

greg_deckler · Answer

Giuseppe_a97&nbsp;Use a disconnected time table with the hours you want to track and this measure. PBIX is attached below signature.
Measure = 
    VAR __Table = 
        SELECTCOLUMNS(
            FILTER(
                GENERATE(
                    'Table',
                    'Times'
                ),
                [Hour] &gt;= [departure hour] &amp;&amp; [Hour] &lt;= [arrival hour]
            ),
            "Train",[train],
            "Hour",[Hour]
        )
    VAR __Table1 = GROUPBY(__Table, [Train], "Count", COUNTX(CURRENTGROUP(),[Hour]))
    VAR __Result = COUNTROWS(__Table1)
RETURN
    __Result

Forum Discussion

Power bi desktop function (representation)

3 Replies

Related content

Bradley Terry score representation - visuels?

PowerBI Desktop Freeze Pane Function

Better visual representation

DATESYTD function

graphic representation