Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
I have a table visual where I created a datediff measure for Day 1 and Day 2 across various projects.
I would like to calculate the achievement rate in percent for Day 1 and Day 2. i.e, I would like to translate these totals from >7days, <7days & >14days to percentage. For instance, if the total duration for all projects on Day 1 is less than 7 days, the achievement rate should be 100%.
Please how do I achieve this?
Please find the image below
Thank you.
Hi
Not sure about your entire calculation, I just created a table and apply the below measure
t1 =
SWITCH(
TRUE(),
SELECTEDVALUE(Test[Day1]) = "<7d",1,
SELECTEDVALUE(Test[Day1]) = ">14d", 0.5,
BLANK()
)
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |