Forum Discussion
% 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 ...
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
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
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