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 guys! I need your help . My goal is to create a calculated measure that will give me the following:
(number of rows where person i is both the start and end) ÷ (number of rows where person i is the start)
where i is A,B,C,D or E (Person Start or Person End)
My raw data looks somewhat like this, this is around 1K rows
I need the calculated measure (Quotient) such that when it is dragged into a Table Visualization along with Person Start, I will get something that looks like this (ignore X and Y columns)
I'm hoping you could help me with this problem!
Thanks!
Solved! Go to Solution.
Hi @Anonymous,
X number of rows where person i is both the start and end = CALCULATE ( COUNT ( Table3[Person End] ), FILTER ( Table3, Table3[Person End] = Table3[Person Start] ) ) Y number of rows where person i is the start = COUNT(Table3[Person Start]) Quotient (X/Y) = [X number of rows where person i is both the start and end]/[Y number of rows where person i is the start]
Best regards,
Yuliana Gu
Hi,
Share the link from where i can download your Excel file.
Hi @Anonymous,
X number of rows where person i is both the start and end = CALCULATE ( COUNT ( Table3[Person End] ), FILTER ( Table3, Table3[Person End] = Table3[Person Start] ) ) Y number of rows where person i is the start = COUNT(Table3[Person Start]) Quotient (X/Y) = [X number of rows where person i is both the start and end]/[Y number of rows where person i is the start]
Best regards,
Yuliana Gu
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 |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |