Forum Discussion
Using What-if parameter for a Custom column written with DAX for True or False (Example in Post)
jbinder4 Step 1. Use a SWITCH(TRUE()...) statement instead of nested IF statements. Will clean up the code tremendously!
Step 2. Create a measure using the same code as the calculated column but use aggregations whenever you refer to a column. Probably can use MAX for the most part. like instead of TicketInfo[PriorityName] = "1-Urgent" it would be MAX(TicketInfo[PriorityName]) = "1-Urgent".
Step 3. Create a table visualization that essentially has the same layout as your base table or otherwise make sure that each row is unique in the table visualization the same way each row appears in your data table. Add your measure to this table visual.
This is based upon what I *think* you are trying to accomplish. I may be incorrect in some assumption.
Greg_Deckler Hello,
Thank you so much for your help thus far! I have went through and tested and tampered with your different steps you layed out for me in your last post. I have had a bit of trouble getting the correct output for the measure when I put it in a table visualization. I also had trouble understanding how to correctly implement the SWITCH(TRUE() functions to replace the nested IF statements.
This is completely far too much to ask, but is there any way I could set up a half hour meeting with you via MS teams to share screen and walk through some ideas? I have ran out of resources within my organization and Youtube has been barren for help considering how situational this issue is.
Let me know if there is any way this could be possible. If not I completely understand, and I am very grateful for the help you've already given me! This lead me to progress a bit with the project and I was stuck in quick sand for a long bit before.
If you are able to swing something you can reach me at: [email protected]
Thank you!