CODEWITHSUNDEEP
powerbipowerbi-desktopdata-modelingmicrosoft-fabric
variable
variable

Reputation: 9714

How to optimize a data model with bidirectional filtering?

I have Product dim that filters the FactSales (1:M)

And Charges dim that filters the FactCharges (1:M)

There is a bridge table with a key value (concat of saleid, poid). This has a 1:M relation with FactSales and FactCharges.

Suppose my user selects a ChargeDesc, then I want to display all the related sales records. To achieve this I have enabled bi direction relation between BridgeTable and FactSales, and between BridgeTable and FactCharges.

This works fine until select more than one month worth of data which results in visual exceeded resources (1024MB). What is the approach to improve this?

Upvotes: 0

Views: 17

Answers (0)

Related Questions