Forum Discussion

porjaiko's avatar
porjaiko
Frequent Visitor
6 years ago
Solved

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

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: %Distribu...
General Comment
Need Help
Tips and Tricks
  • v-xuding-msft's avatar
    v-xuding-msft
    6 years ago

    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's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

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.