powerbi - Power Bi | Analysis Services | Working with Mixed Model

Question

I am working with an Analysis Services Model which works on Live Connection.

With the December Power Bi Update we can add local tables also and make the model mixed.

So in my mixed model, i want to create a measure to substract 2 columns(one from live connection and one from local).

Live Connection Table

| Layer    | Limit          |Deductible      |
| -------- | -------------- | -------------- |
| 5xs5     | 5000000        |5000000         |
| 10x10    | 10000000       |10000000        |
 

Local Table

Claim   Incurred
1        5494849
2        2025357
3        74282
 

I want a measure IncurredAboveDeductible, which will substract Incurred from Deductible

Claim   Incurred    Layer   Deductible  IncurredAboveDeductible
1       5494849     5x5      5000000     494849
1       5494849    10x10    10000000     0

question from:https://stackoverflow.com/questions/66066337/power-bi-analysis-services-working-with-mixed-model

Answer 1

Waitting for answers