Forum Discussion
Solved
How to show missing values from a reference based on a key from an answer
Hi Everyone. I'm kind of new to Power BI, but i've been working hard on a report these days. My problem is: I have a fix reference table and an answers table (based on a key) shown bellow ...
Hi Quartarolo
0. Change the name of the Reference[Fixed Answers] column to Reference[Answer]
1. Place Answers[Key] in the a table visual
2. Create this measure and place it on the visual
Missing answer = VAR answers_ = DISTINCT ( Answers[Answer] ) VAR refAnswers_ = ALL ( Reference[Answer] ) VAR missing_ = EXCEPT ( refAnswers_, answers_ ) RETURN CONCATENATEX ( missing_, [Answer], ", " )Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Hi Quartarolo
0. Change the name of the Reference[Fixed Answers] column to Reference[Answer]
1. Place Answers[Key] in the a table visual
2. Create this measure and place it on the visual
Missing answer =
VAR answers_ =
DISTINCT ( Answers[Answer] )
VAR refAnswers_ =
ALL ( Reference[Answer] )
VAR missing_ =
EXCEPT ( refAnswers_, answers_ )
RETURN
CONCATENATEX ( missing_, [Answer], ", " )Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers