Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Substracting Two Measures

Hi,   I have two, relatively simple sum measures that produce two sets of counts. Measure1 100 250 10   Measure2 1500 1000 50   Then I have a simple subtraction measure, Measure2-Measure...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi Anonymous,

 

Can you share a sample file, please? You post the result here. I'm afraid we can't find out the reason. 

If these measures are evaluated in the same context, it should be correct. But we don't know if there is any context conversion in the measures. 

 

 

Best Regards,
Dale

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks for your reply Dale. Unfortunately, the data is sensitive. I recreated the pertinent portions but the error was not reproduced in those portions, leading me to believe the error exists somewhere within the pre-built model I'm pulling from.

 

 

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    7 years ago

    Hi Anonymous,

     

    Did you solve the issue? If you can't share the data, you can share some snapshots and the formulas at least.

     

     

    Best Regards,
    Dale

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      External dependencies will have to resolve this issue unfortunately, I've ruled out problems I can diagnose or solve for from my end in terms of formulas. I'll respond back if/when a solution is reached on this, thanks.