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.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

Anonymous - Hard to tell what is going on from the post. Please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks,

    It was my first ever post here but thanks.