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

  • rajendraongole1's avatar
    rajendraongole1
    Super User
    2 years ago

    Hi Satyam7054 - Yes, i have analyzed the file shared. i have taken example for a date highlighted 17-03-2024

     

    Getting the below result when i select the date and project name as per below snapshot:

     

     

    Model FYR: Changed the relationship from Drinking water works to Project master table.

    Above is the expected output as per shared excel file. we are getting. 

     

     

     

    Kindly let me know if that works, if not kindly share what is expected from your end on date level or project master wise.

     

    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

      Hi rajendraongole1 Ji Thank you for your assistance so far, but the issue still isn't resolved. Now, it cannot filter by Village Name, and the Project filter is also not appearing.

      I want to create relationships among all the tables in my Power BI file, making the Project Name and Date slicers the master slicers. This will allow me to filter different tables' projects along with the timeline simultaneously.

      For example, I want to create a dashboard where each table contains some data. I want to filter this data using both the Project slicer and the Date slicer.

       

      • rajendraongole1's avatar
        rajendraongole1
        Super User
        2 years ago

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