Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

% graph by month

Hello Power BI community,   There is a data that I am working with , one of the column has value  <1.33 or >1.33 The count graph looks like this,   But target graph is percentage of >1.33 ...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    6 years ago

    Anonymous 

     

    I assume you have the calendar table and build relationship with the tale you shared.

     

    Measure = 
VAR _count=COUNTROWS('Table')
VAR _count2= CALCULATE(COUNTROWS('Table'),ALLEXCEPT(datetime,datetime[month]))
return _count/_count2

ryan_mayu's avatar
ryan_mayu
Super User
6 years ago

Anonymous 

 

 

Try this measure and put measure in the value field.

% = sum('Table'[value])/CALCULATE(SUM('Table'[value]),ALLEXCEPT('Table','Table'[month]))

Hope this is helpful.

 

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hello ryan_mayu :

 

You are so close. 

The way I have the data is a little different 

 

Can you please tell me how to do it with the data like this?

 

Thank you in advance,

 

Rushi Sathi

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    6 years ago

    Anonymous 

     

    I assume you have the calendar table and build relationship with the tale you shared.

     

    Measure = 
VAR _count=COUNTROWS('Table')
VAR _count2= CALCULATE(COUNTROWS('Table'),ALLEXCEPT(datetime,datetime[month]))
return _count/_count2