Two level DAX functions

Question

I am doing a dashboard for a survey results&nbsp;One of the problem I faced is two level dax function.Example: Q6a&nbsp; - who did approach for help?&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Ans :&nbsp; 1. Booths&nbsp; &nbsp; 25&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2. Internet&nbsp; &nbsp;27&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3. Friends&nbsp; &nbsp;28&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4. Schools&nbsp; 49&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Q8&nbsp; - where search engines did you use ?&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Ans:&nbsp; 1. Yahoo&nbsp; &nbsp; 4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2. Google&nbsp; &nbsp;3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3. Amazon&nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4. Apple&nbsp; &nbsp;1&nbsp;The numbers are the responses&nbsp;Those who answered Internet for Q6a will proceed to answer Q8The total responses for Q8 is not 27&nbsp;I need to show a bar chart for top 3 Q8 who have replied Internet for Q6a&nbsp;

fowmy · Answer

mkathi0405&nbsp;Yes, it is possible but can you share your sample data in the format that you have?

v-xulin-mstf · Answer

Hi&nbsp;mkathi0405,
&nbsp;
If I understand correctly, there should also be a user table.
I'm not sure about your data structure.
Could you provide sample data and expected output after removing sensitive data?Sample data and expected output would help tremendously.
&nbsp;
Best Regards,
Link
&nbsp;
Is that the answer you're looking for? If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution. Really appreciate!

v-xulin-mstf · Answer

Hi&nbsp;mkathi0405,
&nbsp;
Is your issue solved?
If you still have some question, please don't&nbsp;hesitate to let me known.‌‌
&nbsp;
Best Regards,
Link
&nbsp;
Is that the answer you're looking for? If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution. Really appreciate!

Forum Discussion

Two level DAX functions

3 Replies

Related content

Role Level Security

DATESYTD function

Page level security

function behavior

DAX Studio space after function name