Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Measurement by Month

Hi, I'm new with Power BI, I'm have some measures consist of working and idle time percentage for each month. When I trying to combine the measures in one stacked chart it become like this.  Ho...
Need Help
Show and Tell
  • v-angzheng-msft's avatar
    v-angzheng-msft
    4 years ago

    Hi, Anonymous 

     

    Obviously, the February data above contains data from January. You need to try to make the January measure calculate to 0 when it encounters the February time.

    You can either recreate the measure, or add a judgment condition to the above measure when calculating it,

    for example:

    IF([month]="January",[Percentage Idle Sum (JAN)],0)

     

    Or, please consdier sharing some dummy data and draw a simple picture to show your expected visual , then I can try to look into it to come up with a more accurate measure.

     

     

    Best Regards,
    Community Support Team _ Zeon Zheng


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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , Based on what I got, you need measure that give you % by month. You have measures for each month like Jan /Feb , that will not work.

 

Please share measure formula

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago
    Percentage Idle Sum (JAN) =
    VAR Totwork=
    SUMX(
    JAN,
    HOUR(JAN[Idle]) + MINUTE(JAN[Idle])/60
    )
    VAR ToTalAll=
    SUMX(
    JAN,
    HOUR(JAN[Idle]) + MINUTE(JAN[Idle])/60 + HOUR(JAN[Working ]) + MINUTE(JAN[Working ])/60
    )
    VAR final =(Totwork/ToTalAll)*100
    RETURN
    final

    Percentage Working Sum (JAN) =
    VAR Totwork=
    SUMX(
    JAN,
    HOUR( JAN[Working ]) + MINUTE( JAN[Working ])/60
    )
    VAR ToTalAll=
    SUMX(
    JAN,
    HOUR( JAN[Idle]) + MINUTE( JAN[Idle])/60 + HOUR( JAN[Working ]) + MINUTE( JAN[Working ])/60
    )
    VAR final =(Totwork/ToTalAll)*100
    RETURN
    final






    • amitchandak's avatar
      amitchandak
      Icon for Super User rankSuper User
      4 years ago

      Anonymous , Are these snapshot tables ?

      each month you have data for the last n months. What is the expected output?

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        I expected each months have the percentage of working and idle