Power BI Dynamic Questionaire - Help with DAX

[Bali2022]

Hi there!  I want to create a "decision support tool"  in Power BI that helps users decide on which labor type (e.g. Contingent Worker, Full-Time Employee, or Statement of Work) they should employ for a project.  I've setup a table in PBI that I'm calling "QuestionFlow" (see below).  Based on the users Yes/No answers to the various questions I either want another question to display or a specific text value to display for the user.  I've created another table called "UserResponse" which simply has values of "Yes" and "No" and then I created a slicer from that.  At this point I'm stuck on the DAX to write (I'm a rookie) in order to dynamically display the series of questions/text based on the user's responses.  Any guidance would be greatly appreciated!

[Anonymous]

Hi @Bali2022 

Can you provide detailed sample pbix file and the results you expect.So that I can help you better. Please remove any sensitive data in advance.

Best Regards,

Jayleny

[Bali2022]

Hi @Anonymous  -  Here is a link to my sample PBI file:

Sample PBI file 

Within the file if you look at the "QuestionFlow" table the records in this table represent the question flow I want the user to run through starting with the question under "QuestionID" Q1.  After they answer this question with either a "Yes" or "No" response this will determine the next QuestionID and QuestionText they are presented with.  In the "Report View" of the attached file I've started to place "Card" and "Slicer" visuals on my canvas to display the various questions and user responses but I can't seem to get the associated DAX measure code correct in order to properly run through the "QuestionFlow".  Hopefully what I'm looking to accomplish is clear.  If not please let me know and I'll try to clarify.  Thanks very much for your help!

[Bali2022]

This is what my "QuestionFlow" Table looks like...