Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi everyone,
I am using a composite model -- local source (A) and power bi dataset with DirectQuery mode (B). For source B I have created the following measure.
m1 = SUM('Table (2)'[Gross VONB USD])
m2 = SUM('Table (2)'[ANP USD])
m3 = DIVIDE( [m1] ,[m2] , "n/a")
Then the relationship is created in the composite model.
If I include both columns of source A (i.e. Column1), columns of source B and measure m3 in the visual, it will report the following error.
This error occurs on Power BI Desktop and Power BI Service. I know a workaround is to recreate a new measure in the composite model to replace m3, but I would like to know if this is a bug and when it will be fixed.
Here is my sample data.
source B:
PLAN_CD | ANP USD | Gross VONB USD |
a | 0 | 0 |
b | 0 | |
c | 1 | 0 |
d | 2 | 0 |
e | 3 | 4 |
f | 4 | 0 |
g | 5 | 5 |
h | 0 | 6 |
i | 0 | |
j | 0 | 0 |
k | 6 | 9 |
l | 7 | |
m | 8 | 23 |
n | 9 | 11 |
source A:
Column1 |
a |
a |
b |
c |
d |
e |
f |
g |
h |
i |
j |
k |
l |
m |
n |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @winner-zlx
I have submitted it to ICM , the ID is 353248649 .If there is news, I will come back to update .
Best Regards,
Community Support Team _ Ailsa Tao