Forum Discussion

Javierco's avatar
Javierco
Icon for Helper I rankHelper I
4 years ago
Solved

results in desktop differ from those published

my report connects to Azure Data Lake Gen 2 and combines several files from a different folders.   When I see results in desktop, everything looks just fine. But after publishing the report (did it...
Need Help
  • Javierco's avatar
    Javierco
    4 years ago

    Ok, I fixed it.

     

    I noticed that one column involved in the calculation was not being cast as a decimal number. Enforcing that and changing locale configuration to set the point as a the decimal separator solved it.

v-xiaotang's avatar
v-xiaotang
Icon for Community Support rankCommunity Support
4 years ago

Hi Javierco 

Preliminary guesses have these two possibilities. The information on the service is updated, or the data is filtered.

Please try this measure, it will clear the filter on table sellout_v2,

Sellout (USD)_v2 =
SUMX (
    ALL(sellout_v2),
    DIVIDE ( ( sellout_v2[amount] ), sellout_v2[Closest currency by date], 0 )
)

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

Javierco's avatar
Javierco
Icon for Helper I rankHelper I
4 years ago

Ok, I fixed it.

 

I noticed that one column involved in the calculation was not being cast as a decimal number. Enforcing that and changing locale configuration to set the point as a the decimal separator solved it.