Hi guys!
I have a measure that calculates the number of visits per week for each client, allowing to group the data dynamically depending on the filters of date, region, etc.
Then, I created the measure 2 Categorized Visits =
VAR deliveries = [AverageVisitsPer Week]
RETURN
SWITCH(
TRUE(),
deliveries = 0, "0 visits",
deliveries > 0 && deliveries <= 1, "0 to 1 visits",
deliveries > 1 && deliveries <= 2, "1 to 2 visits",
deliveries > 2 && deliveries <= 3, "2 to 3 visits",
deliveries > 3, "3 or more visits"
)
to categorize customers depending on the number of visits.
My problem is that I need a table where I can see the categories as columns, the regions as rows and in values the percentage of customers in each category. It is not possible to directly put a measure to the column section, only the value section. I tried to create a column inside my table that calculates the category for each customer, but it doesn't work. I understand that it is because the category depends on a measure that is dynamic and cannot be obtained statically in a table.
Any ideas on how this can be solved? I really appreciate your help, I am new to power BI and this problem has been a lot harder than I expected.
Thanks for reading me!
