Forum Discussion

Bali2022's avatar
Bali2022
Frequent Visitor
2 years ago

Power BI Dynamic Questionaire - Help with DAX

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 fo...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
Bali2022
Frequent Visitor
2 years ago

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!