Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Divide in Power BI

Hi Everyone,   I am new to Power BI and DAX funcation, I have making report on power BI and I have Load Id number which I used as count function in PB so see how many load I have. Each load have di...
Tips and Tricks
  • v-xicai's avatar
    v-xicai
    6 years ago

    Hi FarhanAhmed ,

     


     

     

     

     

     

     

     

     

    For the data you share, you may create two measures instead of calculated column like DAX below.

     

    % OTAS = DIVIDE(SUM('Data (2)'[OTAS] ), SUM('Data (2)'[Loads] ))



% OTAW = DIVIDE(SUM('Data (2)'[OTAW] ), SUM('Data (2)'[Loads] ))

     

    Then you may choose Clustered column chart to display result, put [Stop] into Axis box of chart, put the new created measures [% OTAS] and % OTAW[] into Values box.

     

    Note that the first link you shared can't be opened, and the [Loads] can't be found in your second pbix link, while it appears in forum shared data above, so does it really exist in your data table?

     

    Best Regards,

    Amy 

     

    Community Support Team _ Amy

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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Farhan,

Are you able to see my data file?

Stop NoBOL countBOLWeekLoad IdStop #Stop TypeStop Window CloseScheduled ArrivalScheduled DepartureScheduled DurationActual ArrivalActual DepartureActual DurationLate Arrival Reason CodeDispatch Time Depart Gate TimeActual Gate TimeDayOTDOTA to TMS scheduled OTA to Window
01Y4810020193011PK2019-12-01 05:042019-12-01 00:312019-12-01 01:013.132019-11-29 21:222019-11-30 23:4426.4SG - System Generated2019-12-01 00:312019-12-01 01:012019-11-30 23:441Y  
10N010020193012DL2019-12-01 05:052019-12-01 02:052019-12-01 02:353.132019-12-01 00:492019-12-02 10:2533.6SG - System Generated     YY
01Y4910020203081PK2019-12-01 09:592019-12-01 02:282019-12-01 02:587.862019-11-30 13:252019-12-01 02:2913.1SG - System Generated2019-12-01 02:282019-12-01 02:582019-12-01 02:291Y  
11Y010020203082DL2019-12-01 07:002019-12-01 05:302019-12-01 06:037.862019-12-01 04:512019-12-01 05:380.8SG - System Generated     YY
21Y010020203083DL2019-12-01 08:002019-12-01 06:232019-12-01 07:037.862019-12-01 05:542019-12-01 06:541SG - System Generated     YY
30N010020203084DL2019-12-01 10:002019-12-01 08:002019-12-01 08:347.862019-12-01 07:542019-12-01 08:360.7SG - System Generated     YY
01Y4910020203121PK2019-12-01 12:292019-12-01 03:212019-12-01 03:5110.42019-12-01 13:272019-12-01 02:23 <Enter Reason Code>2019-12-01 03:212019-12-01 03:512019-12-01 02:231Y  
11Y010020203122DL2019-12-01 10:002019-12-01 07:002019-12-01 07:3610.42019-12-01 05:302019-12-01 06:301NS - Normal Status     YY
21Y010020203123DL2019-12-01 11:002019-12-01 08:032019-12-01 08:3810.42019-12-01 07:052019-12-01 07:530.8SG - System Generated     YY
30N010020203124DL2019-12-01 12:302019-12-01 10:362019-12-01 11:2910.42019-12-01 09:502019-12-01 10:581.1SG - System Generated     YY
01Y4910020203201PK2019-12-01 08:592019-12-01 03:282019-12-01 03:584.592019-11-30 14:272019-12-01 03:2913SG - System Generated2019-12-01 03:282019-12-01 03:582019-12-01 03:291Y  
11Y010020203202DL2019-12-01 08:002019-12-01 05:002019-12-01 06:064.592019-12-01 04:292019-12-01 05:130.7SG - System Generated     YY
20N010020203203DL2019-12-01 09:002019-12-01 06:252019-12-01 07:034.592019-12-01 05:412019-12-01 06:330.9SG - System Generated     YY
01Y4910020198661PK2019-12-01 09:592019-12-01 03:552019-12-01 04:255.712019-12-01 13:102019-12-01 04:38 <Enter Reason Code>2019-12-01 03:552019-12-01 04:252019-12-01 04:381N  
10N010020198662DL2019-12-01 08:002019-12-01 06:002019-12-01 06:455.712019-12-01 06:532019-12-01 08:011.1SG - System Generated     NY