Forum Discussion

Sofinobi's avatar
Sofinobi
Helper IV
2 years ago

Rating visual

Hi all,

please, i have a dax measure to show a star rating (not exactely stars), but it doesn't work, it shows me an error "mdxscript(model) (346, 30) calculation error in measure"
the measure is :  

Rating Visual =
VAR _Full = INT( DIVIDE(AVERAGE(COM_ThirdParty[Rating Column]),10) )
VAR _Empty = 10 - _Full
RETURN
REPT(UNICHAR(9899), _Full) & REPT(UNICHAR(9898), _Empty)

* the error comes from the rating column, cause when i change for another column, it shows me a result correctely.
the Rating Column is calculated :  
Rating Column = DIVIDE([Sales],[Solde Max],0)*100

the result with another column is like this image:

2 Replies

  • Sofinobi's avatar
    Sofinobi
    Helper IV
    2 years ago

    hi again,
    after trying some manipulations, now it works for the Sellers, but not for the Clients.
    here is a sample pbix file, 
    Rating test.pbix 
    my actual result in this image: (i woukd like the same for the Clients)

    thank you so much