Forum Discussion

Mahmoud_nabir's avatar
Mahmoud_nabir
Frequent Visitor
7 years ago

Relation active but not working

i have 3 tables

HH_Customer  (customer Data)

SKYDIST_PLANNED_VISITS_TOTALS_details (planned visits for each customer ber Week Day)

Table (count planned visir for each weekDay)

-i have relation between SKYDIST_PLANNED_VISITS_TOTALS_details[Cutomerid] and HH_Customer[customerid]

- relation between Table[Visitday] and SKYDIST_PLANNED_VISITS_TOTALS_details[Visitday]

 

i have calculated the planned visit by each weekday as shown on Table[Column]

 

result is accurate but i have problem when filter by customer category

 

as i have categoris on customer i want to choose the category then reflect with the Table [Column]

 

it reflect on count(SKYDIST_PLANNED_VISITS_TOTALS_details) but not reflect on Table[Column] 

as shown on Picture 4 & 5

 

SKYDIST_PLANNED_VISITS_TOTALS_detailsTable

 

45

Need Help

3 Replies

  • Mahmoud_nabir's avatar
    Mahmoud_nabir
    Frequent Visitor
    7 years ago

    Column calculated with below code

     

     

    Column = CALCULATE(COUNT(SKYDIST_PLANNED_VISITS_TOTALS_details[CustomerID]),FILTER(SKYDIST_PLANNED_VISITS_TOTALS_details,SKYDIST_PLANNED_VISITS_TOTALS_details[visitday]='Table'[visitday]) )

  • affan's avatar
    affan
    Solution Sage
    7 years ago

    Hi Mahmoud_nabir,

     

    Instead of sharing the image it will be easier to resolve your issue if you can share a pbix file with sample data and also the desired results.

     

    Regards,

    Affan

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    7 years ago

    Hi Mahmoud_nabir,

     

    I think that should be the issue of the relationship between tables in your model. kindly share your pbix to me.

     

    Regards,

    Frank