Need You Help!: row Total sum % over 100%

[porjaiko]

Need You Help!: row Total sum % over 100%, It's mistake.

I need show total = 100%

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

               and convert to % 

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

Could you advise me about this?

Thank you

[v-xuding-msft · Accepted solution]

Hi @porjaiko ,

The formula is calculating division of [Store Active] and [Total Store Visit]. So the grand total is calculating as well.

141189 / 6519 ≈ 21.6581  (2165.81%)

[amitchandak]

@porjaiko , looking at % , it does not look like it will sum up to 100%.  The formula has an issue. Can not tell without looking at data

May be

%Distribution = DISTINCTCOUNT(VW_ANSWER_BRNCODE_POSITION_LEG_OUTOFORDER_1344[SKUs]) / DISTINCTCOUNT(VW_ANSWER_BRNCODE_POSITION_LEG_OUTOFORDER_1344[BRN_CODE])

Can you share sample data and sample output.