Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

REDO mesures without RELATEDTABLE

Hello,

 

I could not find the answer on youtube, so I ask some help here.

I ve got a new dataset to manage which was made not by me. It is very slow and I can't export many visuals to powerpoint directly because it lacks on memory.

After investigation - the problem is RELATEDTABLE in DAX syntax - I was able to redo some mesures without relatedtable and it works just fine, but for some mesures I have different result, and old result with RELATEDTABLE is a right one.
So my question is there any general tip to get rid of RELATEDTABLE and make my dax more fluent.
Example of slow mesure: 

Base-TotalEng = 
CALCULATE(
[base-F2F]+
[base-Phone]+
[Base-S2S]+
[Base-event]+
[base-FUE]+
[Base-Remote]+
[base-NLADOBE]+
[base-Web]
,RELATEDTABLE('Target')
,RELATEDTABLE('Decision'))

Thank you

relatedtable
slow

2 Replies

  • tamerj1's avatar
    tamerj1
    Community Champion
    4 years ago

    Anonymous 

    Try using CROSSFILTER - BOTH instead of RELATEDTABLE for both tables

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Community Support
    4 years ago

    Hi Anonymous,

    Can your problem resolve by tamerj1 's suggestion? If so, would you mind accept his reply as solution? Then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.

    Additionally, please see if this blog helps: DAX: Data Modeling with RELATED & RELATEDTABLE

     

    Best Regards,
    Community Support Team _ kalyj