Forum Discussion

wilchy's avatar
wilchy
Regular Visitor
4 years ago
Solved

Help with percentage difference in Power BI

Hello,   I am totally new to Power BI and have decided to try and put together a dashboard for my line of work in wind turbines. I basically want to be able to show the percentage of what turbines ...
Need Help
  • davehus's avatar
    davehus
    4 years ago

    Hi wilchy ,

     

    Try 

    Turbine Count = COUNT(Turbine[Turbine Number])

Turbine % = VAR Operational = CALCULATE(Turbine[Turbine Count], KEEPFILTERS(Turbine[Turbine Status] = "Operational"))
RETURN DIVIDE(Operational,Turbine[Turbine Count])

    Adjusted the tables and columns in the sample to your needs. You build out a matrix with just the windfarm and the values to get availability of each.

     

     

     

    Did I help you today? Please accept my solution and hit the Kudos button.

wilchy's avatar
wilchy
Regular Visitor
4 years ago

Thanks for such a quick response to my issue. Could you please tell me where I add you formula that you have done for me? Sorry I am a total beginner at this stuff. Thanks

NickolajJessen's avatar
NickolajJessen
Icon for Solution Sage rankSolution Sage
4 years ago

I think some basic videos would be good for you right now.

 

You can search youtube for "Creating measures Power bi". That should get you started 🙂 

  • davehus's avatar
    davehus
    Icon for Memorable Member rankMemorable Member
    4 years ago

    Hi wilchy , As NickolajJessen mentioned, head over to youtube. You'll find loads of resources relating to PowerBI on it. 🙂