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,
Trying to create a Ball in Court filter. I currently have a Status column with multiple statuses (i.e., closed, draft, open (in review), etc.)
If Status =
Closed = AW
Draft = AW
Open (In review) = BC
Open (Reviewed) = AW
Open (Submitted) = AW
Open (Waiting for Submission) = Sub
Thanks,
Pablo
Solved! Go to Solution.
Hi Pablo,
here's a reference formula based on test data. If you complete it with your case categories it should work.
TestColumn =
SWITCH (
TRUE (),
'Table'[Status] = "Expired", "AW",
'Table'[Status] = "Open", "BC"
)
Best regards,
Tim
Proud to be a Super User!
Hi Pablo,
I am not sure if I got your question correct: You want to aggregate the different status e.g. Open (reviewed) and Open (Submitted) should be summarized as "AW"?
If so, I would suggest to create a calculated column in DAX that uses the SWITCH-function (https://docs.microsoft.com/en-us/dax/switch-function-dax).
The formula could look like this:
= SWITCH ( [Status_short], "Closed" = "AW", "Draft" = "AW" [...further expressions])
Looking forward to see if I was able to help you!
Cheers
Robin
@PabloGiraldo I guess you are trying create three groups basis the status. I would suggest you to use the group function. Right click on the status column and select new group
then you can create three groups for your values and you can use it instead of values of status column. I hope it helps you
Proud to be a Super User!
Hi Pablo,
here's a reference formula based on test data. If you complete it with your case categories it should work.
TestColumn =
SWITCH (
TRUE (),
'Table'[Status] = "Expired", "AW",
'Table'[Status] = "Open", "BC"
)
Best regards,
Tim
Proud to be a Super User!
Got it working. Thanks!
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 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |