Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Table relationship inbetween

Hey there Community,   I am relatively new to PowerBI, therefore I'd really appreciate the help. I am currently trying to create a dashboard for my real estate company with data out of dynamics 36...
Need Help
  • DataInsights's avatar
    DataInsights
    5 years ago

    Anonymous,

     

    You could use the CROSSFILTER function inside CALCULATE:

     

    Count Real Estate Objects =
CALCULATE (
    COUNT ( ink_realestateobjects[ink_realestateobjectid] ),
    CROSSFILTER ( ink_lead_ink_realestateobjectset[ink_realestateobjectid], ink_realestateobjects[ink_realestateobjectid], BOTH )
)

     

DataInsights's avatar
DataInsights
Super User
5 years ago

Anonymous,

 

You could use the CROSSFILTER function inside CALCULATE:

 

Count Real Estate Objects =
CALCULATE (
    COUNT ( ink_realestateobjects[ink_realestateobjectid] ),
    CROSSFILTER ( ink_lead_ink_realestateobjectset[ink_realestateobjectid], ink_realestateobjects[ink_realestateobjectid], BOTH )
)