Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
Try like
ontime = calculate(countrows(table),Ontime/Delayed="Ontime")
total = calculate(count(table[Empl ID]),ALLEXCEPT(table[Month])
% =divide(ontime,total)
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
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
Try like
ontime = calculate(countrows(table),Ontime/Delayed="Ontime")
total = calculate(count(table[Empl ID]),ALLEXCEPT(table[Month])
% =divide(ontime,total)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |