Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
142 | |
71 | |
64 | |
52 | |
50 |
User | Count |
---|---|
208 | |
91 | |
62 | |
59 | |
56 |