Forum Discussion

AnthonyMCUBI's avatar
AnthonyMCUBI
Frequent Visitor
5 years ago

Complex table relationships

Hi everyone,   I'd like to create a measure in a table that has a relationship with a calculated date table. The date table is what we use to do all of our time-related filtering. When creating a v...
Need Help
MFelix's avatar
MFelix
Super User
5 years ago

Hi AnthonyMCUBI ,

 

Without a sample data and your sintax is difficult to givbe the exact answer but using the use of FILTER and ALL or the CROSSFILTER set to NONE will deactivate the use of the relationship.

 

Has you can see in the image below I have an active relationship but using the cross filter I was abble to make the sum being different from the current month:

 

Can you please share a mockup data or sample of your PBIX file and expected resutl. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.

AnthonyMCUBI's avatar
AnthonyMCUBI
Frequent Visitor
5 years ago

Hi MFelix ,

 

Here is the WeTransfer link to the example report: https://we.tl/t-psTz6NEKBz. It contains another attempt to create a Running Balance measure in the '*ACM Cylinder History' table; that method works but is unacceptably slow, so I'm still looking for a solution. I have another post on this forum about the performance of that implementation here if you're curious https://community.powerbi.com/t5/Desktop/Performance-Between-Two-Measures-How-to-make-the-slower-one-more/m-p/1750576#M688198.

 

Thank you.

  • MFelix's avatar
    MFelix
    Super User
    5 years ago

    HI AnthonyMCUBI ´,

     

    Thak you for the file, but can you tell me what is the expected result that you are wainting for?

     

    I have made the same visualization has you but not really sure about the final result.