May be Serious bug in the VertiPaq engine (with repo steps)

[Tishchenko]

This bug persists in SSAS 2016 as well ((

Result of this BUG:

(in English locale replace syntax separator ";" to"," and comma in numeric values from ", " to ".")
People = UNION(ROW("Name";"Alex";"Weight";50,55);ROW("Name";"Anna";"Weight";55,56))

Facts = UNION(ROW("City";"Las Gagas");ROW("City";"NY"))
MaxWeight = AVERAGE('People'[Weight])
MaxWeightCopy = [MaxWeight]

BugTable = SUMMARIZE('People';People[Name];"Bug";[MaxWeightCopy])
Dummy = ROW("Dummy";"Dummy")

[v-qiuyu-msft]

Hi @Tishchenko,

In your scenario, you need to place the measure MaxWeight under Facts table, and the measure MaxWeightCopy under Dummy table. When you create a table with below expression:

BugTable = SUMMARIZE('People',People[Name],"Bug",'Dummy'[MaxWeightCopy],"Bug1",'Facts'[MaxWeight])

Both [Bug] and [Bug1] fields display correct values in a table visual. See:

If you have any question, please feel free to ask.

Best Regards,
Qiuyun Yu

[Tishchenko]

@v-qiuyu-msft Hi, can you please explain me, how i'm recive this results   (pbix link)

https://1drv.ms/u/s!AmFuiFSkSTfkgQc9yHZVUhd-CzCo