The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
97 | |
80 | |
62 | |
57 |
User | Count |
---|---|
246 | |
119 | |
114 | |
86 | |
70 |