How to calculate % on monthl totals in measure

[Anonymous]

Hi All,

Need a help on how to define the measure for arriving at the % of monthly . Below is example my table.

Month	Value x	Value Y	Total (X+Y)	% of value X against total
Jan'19	419	1526	1945	27%
Feb'19	149	1630	1779	9%
Mar'19	145	2036	2181	7%

Thanks and Best Regards,

Srihari.K

[amitchandak]

Try like

measure = divide(sum(Table[Value x]),sum(Table[Total X+ Y]))*100

measure = divide(sum(Table[Value x]),sumx(Table,Table[Value x]+Table[Value Y]))*100

* 100 is optional if you plan to show it as %.

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin

[Anonymous]

Dear Amit,

Thanks for your quick solution. I have posted the table wrongly. In this case both X & Y are in the same column

Below is my raw data - where i need to have Month wise % of Ontime reportees & Delayed reportees

Ex: Jan-19 : 75% ontime & 25% delayed

Month	Empl ID	Ontime/Delayed
Jan-19	A	Ontime
Jan-19	B	Delayed
Jan-19	C	Ontime
Jan-19	D	Ontime
Feb-19	E	Ontime
Feb-19	F	Delayed
Feb-19	G	Delayed
Feb-19	H	Ontime
Mar-19	I	Ontime
Mar-19	J	Delayed
Mar-19	K	Delayed
Mar-19	L	Delayed

Thanks in advance for your help

Best Regards,

Srihari

[amitchandak · Accepted solution]

Try like

ontime = calculate(countrows(table),Ontime/Delayed="Ontime")

total = calculate(count(table[Empl ID]),ALLEXCEPT(table[Month])

% =divide(ontime,total)