Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I know there are a couple similar questions, but after looking at the solutions, none of them have worked for me.
I am buildling a report in which you can look someone up and see their fields of interest and fields of expertise. My data is set up with one table containing a list of individuals ('Individuals') and another table with their interests/expertise. Each person may have several interests or expertises, or none at all.
Individual Key | Individual Name |
1001 | Bob Johnson |
1002 | Sam Miller |
1003 | John Adams |
Individual Key | Category | Interest/Expertise |
1001 | Medicine | Interest |
1001 | Hotels | Interest |
1001 | Dogs | Expertise |
1001 | Cats | Expertise |
1002 | Lifestyle | Interest |
1002 | Writing | Expertise |
For the actual report, I would like to show a blank table when a member is not selected, and then when a member is selected, it shows their interests and expertise:
I've tried to play around with variations on this measure:
Solved! Go to Solution.
Hi @Anonymous ,
Modify your measure as below:
Int-Exp Filt = IF ( ISFILTERED ( Individuals[Full Name and ID] )=TRUE(),MAX ( 'Interests and Expertise'[exa_category] ),BLANK())
Hi @Anonymous ,
Modify your measure as below:
Int-Exp Filt = IF ( ISFILTERED ( Individuals[Full Name and ID] )=TRUE(),MAX ( 'Interests and Expertise'[exa_category] ),BLANK())
Refer:
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |