Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
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
@Anonymous
Try using CROSSFILTER - BOTH instead of RELATEDTABLE for both tables
User | Count |
---|---|
42 | |
28 | |
24 | |
20 | |
16 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |