Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I am trying to make a new column including an 'if or' statement which also includes a nested OR. This in the presentation mode (not in query mode)
Can somebody help how I should write this? When writing 'IF(OR(....' the OR is not accepted. OR is marked with a red waved line beneeth.
Thanks in advance.
Solved! Go to Solution.
OK, I created a table like this:
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WCkvMKUstVorViVYKTk0sgbACEvNArFgA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [ARTICLE_GROUP_NAME = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"ARTICLE_GROUP_NAME", type text}}) in #"Changed Type"
And copied your formula into a new column and it worked perfectly. Even as a slicer. Only thing I can think of if you are getting blanks in your slicer is that you have something else filtering the page?
Can you post the full formula? OR is a valid DAX function. For example, this formula is valid in my test:
Measure 2 = IF(OR(MAX('Table1'[Name])="Bloggs",MAX('Table1'[Name])="Smith"),"Smith","Not Smith")
Hi Greg,
This is the formula:
Article_Group = if(OR([ARTICLE_GROUP_NAME]="Valves",[ARTICLE_GROUP_NAME]="Seats"),"Wear_parts","Others")
When I use a slicer, it results in 'blanks'.
Hi @Hyperchef1969,
Have you solved your problem?
If you have solved, welcome to share your solution or mark the right reply as answer. More people will find the solution easily.
If you still need help, could you share a dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)
Best Regards,
Cherry
OK, I created a table like this:
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WCkvMKUstVorViVYKTk0sgbACEvNArFgA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [ARTICLE_GROUP_NAME = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"ARTICLE_GROUP_NAME", type text}}) in #"Changed Type"
And copied your formula into a new column and it worked perfectly. Even as a slicer. Only thing I can think of if you are getting blanks in your slicer is that you have something else filtering the page?
User | Count |
---|---|
98 | |
90 | |
78 | |
72 | |
65 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |