Forum Discussion

Satyam7054's avatar
Satyam7054
Frequent Visitor
2 years ago
Solved

Power Bi Relationship

Hi, I am sharing a Power BI file where there are multiple tables, each containing unique Project Name and Date columns, which are consistent across all tables. I am trying to create a dashboard us...
Need Help
  • rajendraongole1's avatar
    rajendraongole1
    2 years ago

    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!!

Satyam7054's avatar
Satyam7054
Frequent Visitor
2 years ago

Another Screenshot