Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
I'm in the process of optimizing one of our dataset, and I found a really strange issue with one of our measure.
Here the measure :
[# Progressão Vendas] =
VAR ca = SUM(vendasDiariasTop2080[MNT_CA])
VAR n_1 = vendasDiariasTop2080[# Vendas N-1 €]
RETURN DIVIDE(ca,n_1,1)-1
As you can see it generate a quite big FE task.
By tweaking the measure I found what cause this issue, it's the -1 in the return statement. When I remove it the issue is solved.
[# Progressão Vendas] =
VAR ca = SUM(vendasDiariasTop2080[MNT_CA])
VAR n_1 = vendasDiariasTop2080[# Vendas N-1 €]
RETURN DIVIDE(ca,n_1,1)
Why does this happen ? And how can I solve it ?
Thank you very much
try if this is any better
[# Progressão Vendas] =
VAR ca = SUM(vendasDiariasTop2080[MNT_CA])
VAR n_1 = vendasDiariasTop2080[# Vendas N-1 €]
VAR n_2 = DIVIDE(ca,n_1,1)
return n_2-1
Also check if you get DataCallBackIDs in the query plan.
User | Count |
---|---|
25 | |
12 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
12 | |
11 | |
8 | |
6 |