Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I have the main list which contains data with the following columns
Main list
Title. Region
A1. Region1
B1. Region5
C1. Region4
C1. Region3
A1. Region7
A1. Region3
D3. Region3
In this main list all the regions should submit the data for all the titles.
Second list has the list of 60 regions
Title
Region1
Region2
Region3..............
Now In PowerBI I am displaying how many regions have responded for particular title from main lis.
I want to show how many regions haven't responded yet based on the title selection from main list.
Any suggestions will be helpful.
Thank you
Solved! Go to Solution.
Hi @Tony09
There should be a relationship between both tables on the Region columns
Add the Regions from table 2 to a table visual and then add the region column from the first table and do a count on this. Turn this on
You will then see blanks where no Region has been entered. You can then filter in the filter pane just for blanks
Thanks
Joe
If this post helps, then please Accept it as the solution
Hi @Tony09
There should be a relationship between both tables on the Region columns
Add the Regions from table 2 to a table visual and then add the region column from the first table and do a count on this. Turn this on
You will then see blanks where no Region has been entered. You can then filter in the filter pane just for blanks
Thanks
Joe
If this post helps, then please Accept it as the solution
User | Count |
---|---|
96 | |
86 | |
78 | |
72 | |
67 |
User | Count |
---|---|
110 | |
104 | |
84 | |
65 | |
63 |