Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
5 years ago

Need You Help!: Row Total Sum % over 100%

Need sor help!: row Total sum % over 100%, It's an error.

I need the total program 100%

Formula: [Store Active] / [Total Store Visit]

and convert to %

2020-05-13_10-09-19.png

I use the measure: %Distribution á SUM(VW_ANSWER_BRNCODE_POSITION_LEG_OUTOFORDER_1344[SKUs]) / DISTINCTCOUNT(VW_ANSWER_BRNCODE_POSITION_LEG_OUTOFORDER_1344[BRN_CODE])

2020-05-13_10-01-37.png

Could you advise me on this?

Thank you

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    Syndicate_Admin , One number is Sum; another is distinct count, how can that total be 100%?

     

     

    Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.