Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
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
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
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]) )
User | Count |
---|---|
127 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |