The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
A vet has multiple branches.
Callouts are recorded on FactCallouts with the BranchID, PetID and Hours worked for billing.
The reason for the callout (eg broken leg, sore eye and rotten tooth) is logged on FactReasons.
Note that a callouts can have multiple reasons.
Therefore:-
DimBranch and DimPet has a 1:Many relationship with FactCallouts.
FactReason has 1:Many relationship with FactCallouts.
The 1:M filtering direction is preventing the desired totals. (see the relation digram in the PBIX)
How can I make the branch, breed and reason select the correct number of callouts in the green visual please?
Hi @speedramps ,
Not very well understood.What result you want to see ?Can you pls provide a graph of the results you would like to get.
Best Regards
Lucien