Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi
I am working with a orders dataset, and a order_lines dataset. I have created a measure which is called "Switch True":
Solved! Go to Solution.
Hi
I found the mistake
It was the Switch(TRUE()) which was incorrect :
The original measure:
Hi
I found the mistake
It was the Switch(TRUE()) which was incorrect :
The original measure:
can you share a screenshot of how [Is_B2B] evaluates when only B2B is selected vs when all are selected?
Hi
As you can see, I did not but anything explicitly for what it should do when all are selected. I tried, but it did not work, so I just left it empty
Important fact:
The filter that is used is "Is B2B" from the order table, not the measure "is B2B" which I sent a screenshot of
and [Is_B2B] returns "B2B" when B2B is selected in the slicer? not BLANK?
Yes, that is correct.
When B2B filter is selected (from the orders table), the measure (shown in the table) shows B2B
it evaluates to BLANK for "Orders without MMG4", which explains why it goes to the else condition of the SWITCH. SO most likely in Shopify_Orders there are no rows that have both "B2B" and "Orders without MMG4"
If you create this as a dimension table with join with existing column (and put the new one in the slicer), then I think i t should work fine, something like this
IsB2B |
B2B |
D2C |
Hi
I creatde the dimension table and used that as a slicer. Still the same result. Any other suggestions?
I have tried to alter the Has_MMG4 measure as well, but no luck yet
User | Count |
---|---|
103 | |
88 | |
78 | |
71 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |