Forum Discussion
Power Bi Relationship
Hi Satyam7054 - Please find the following comments:
1. The Count of Project Name card, which is sourced from the Drinking Water table, shows 1 entry on the dashboard when applying the SSI Project and Date filters in Power Query shows no entries. --> Please check in Table view not power query editor.
In data view i have filtered with above combinations. we are getting only 1 project name from Drinking water table with mentioned filters. SSI and 17th May 2024 date.
you have to build inactive relationship between tables too
eg:
I have created for VillageName,membername
Village name count = CALCULATE(DISTINCTCOUNT(Grassroot_Cadre_Database[Village Name]),USERELATIONSHIP(Datetable[Date],Grassroot_Cadre_Database[Membership Date]))membername count relation = CALCULATE(DISTINCTCOUNT(Grassroot_Cadre_Database[Member Name]),USERELATIONSHIP(Datetable[Date],Grassroot_Cadre_Database[Membership Date]))visuals are coming as available data results.
you have to check on the model part. please work on it, if require build the inactive relationships and bring the right values to your visualization using DAX functions.
I hope it works. please check
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
Hi Satyam7054 in such scenerio, use project name from Project master table in all the visuals, and date table has to create seperately. (hope it is created).
Take the reference of Village name column from Grassroot_Cadre_Database table, as it is having right relationships with other tables too.
Check the count of villages as per selection of project name and date, it is validated that total count is 49
Please check the model build as below:
Hope it works, Thank you
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
Hi rajendraongole1 JI Thank you for the continued assistance with this issue. However, the filtering is still not working correctly. Here are the specific problems:
1. The Count of Project Name card, which is sourced from the Drinking Water table, shows 1 entry on the dashboard when applying the SSI Project and Date filters in Power Query shows no entries.
2. The Count of Member Name card, which is sourced from the Grassroot Cadre table, should show only 2 entries when filtered by Project Name and Date in Power Query, but the dashboard displays 493 entries. Additionally, the Count of Village Name should only have 1 entry.
3. The Count of Activity card sourced from the Village Level Meeting table is the only one where the filter works correctly.
I am sure you understand the issue now. If there is any other way to resolve this problem, please let me know. I have already created a Master Project and Master Date table and connected them to all relevant tables, which you should be able to see in the mapping.
Please advise on any alternative solutions or corrections that can be made to fix this issue.
for more clarity please see screenshot
Hi Satyam7054 - Please find the following comments:
1. The Count of Project Name card, which is sourced from the Drinking Water table, shows 1 entry on the dashboard when applying the SSI Project and Date filters in Power Query shows no entries. --> Please check in Table view not power query editor.
In data view i have filtered with above combinations. we are getting only 1 project name from Drinking water table with mentioned filters. SSI and 17th May 2024 date.
you have to build inactive relationship between tables too
eg:
I have created for VillageName,membername
Village name count = CALCULATE(DISTINCTCOUNT(Grassroot_Cadre_Database[Village Name]),USERELATIONSHIP(Datetable[Date],Grassroot_Cadre_Database[Membership Date]))membername count relation = CALCULATE(DISTINCTCOUNT(Grassroot_Cadre_Database[Member Name]),USERELATIONSHIP(Datetable[Date],Grassroot_Cadre_Database[Membership Date]))visuals are coming as available data results.
you have to check on the model part. please work on it, if require build the inactive relationships and bring the right values to your visualization using DAX functions.
I hope it works. please check
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!This is working. Thank you so much for your assistance. I will reach out to you if I face any other issues in the future. Thanks ones again.
Satyam