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.
Can anyone help with above error message in below code:
Solved! Go to Solution.
You are telling switch to check for 1 in the [Category] column. There is no 1 in the [Category] column. You either need to have switch look for "Platform Inflow" in the [Category] column or look for 1 in the [CategorySort] column.
Is Category[CategorySort] a number or text, in your formula you are checking it one way first then the other way.
My guess is your problem is here.
SELECTEDVALUE ( 'Inflow Category'[Category] ), 1,
What are the values in the 'Inflow Category'[Category] column becuase the measure is checking if is = 1
If it is 1 maybe it is stored a text in the model? try it with SELECTEDVALUE ( 'Inflow Category'[Category] ), "1",
Hi @jdbuchanan71 Thanks for your reply!
Unfortunately it still doesnt work after I tried with 'SELECTEDVALUE ( 'Inflow Category'[Category] ), "1",".
The values in my table are in the screenshot.
Could it be because I return no values for some of my divide functions as numerator or denominator may be zero? If so, how do I correct that?
If this is not the reason, pls still advise. Thanks!
Can you share what your 'Inflow Category'[Category] table looks like? Your switch is saying look for a 1 in the [Category] column. What are the values in the [Category] column?
Opps I forgot to upload the category table. Here is it. There is 1 in the Category table.
Essentially I am trying to build a waterfall chart where the start point is "platform inflow %" and the end point is "segment inflow %"
You are telling switch to check for 1 in the [Category] column. There is no 1 in the [Category] column. You either need to have switch look for "Platform Inflow" in the [Category] column or look for 1 in the [CategorySort] column.
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 |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |