Forum Discussion

phaum1967's avatar
phaum1967
Resolver I
6 years ago
Solved

Calculation error in measure

Impossible de charger les données de cet élément visuel MdxScript(Model) (10, 79) Calculation error in measure 'public invoices'[QtyKg]: Cannot convert value '<pii>2.73</pii>' of type Text to type Number. Réessayez plus tard ou contactez le support. 

 

It works well in PB desktop, but I have an issue in powerbi services (cant see this graph due to error .

 

this is a sample of tables used and QtyKg formula:

QtyKg = sumx('public invoices','public invoices'[Qty]*'public invoices'[QtyParam])
and 
QtyParam = RELATED(ParamItems[Qty])
 
So  I use 2 tables. First one is invoices :
Fisrt one is like this 
 and second one is ParamItems:
 Both are linekd with id field (unique value in ParamItems to many in invoices) 
 
  • Error was international .

    Just go and modifiy in options local settings.

2 Replies

  • sue could be linked to internatioanl number settings ? As I m in french on my local PB desktop and PB Desktop services is canadian ?

    So not able to understand . versus , ?

    • phaum1967's avatar
      phaum1967
      Resolver I

      Error was international .

      Just go and modifiy in options local settings.