Forum Discussion

Vizbaby's avatar
Vizbaby
Icon for Helper I rankHelper I
1 year ago
Solved

Percentage Total is not accurate

The percentage column for my viz is not adding up correctly.  I have used the formulas below but i keep getting same result. The first two columns are the likely correct result but total is  not cor...
Need Help
  • SundarRaj's avatar
    SundarRaj
    1 year ago

    Hey Vizbaby ,
    I'll attach a file link below. Please have a look at the DAX Code and Data Model to see the fundamental of getting the totals. Let me know in case of any queries. Thanks

    Regards,

audreygerred's avatar
audreygerred
Icon for Super User rankSuper User
1 year ago

I mean you will have to take you response rate or new response rate and do a SUMX in addition to the formula you have - that way it will do the division at the row level, then sum it for the total. The one where you have the sumx is just a distinct count - it's not doing any division to do a percentage.

 

Something like this (without having the sample data I can't confirm it, but something this would figure out the percent for each row then sum them)

 

Response_rate =
VAR TotalResponses = COUNTROWS(New_MasterQuery)
VAR TotalContacts = SUM(Campaign[numberofcontacts])
VAR RowPercentage = DIVIDE(TotalResponses, TotalContacts, BLANK())
RETURN
    IF(
        ISINSCOPE(Campaign[YourGroupingColumn]),
        RowPercentage,
        SUMX(
            VALUES(Campaign[YourGroupingColumn]),
            VAR Responses = CALCULATE(COUNTROWS(New_MasterQuery))
            VAR Contacts = CALCULATE(SUM(Campaign[numberofcontacts]))
            RETURN DIVIDE(Responses, Contacts, BLANK())
        )
    )

Vizbaby's avatar
Vizbaby
Icon for Helper I rankHelper I
1 year ago

Thank u, i just tried your formula and the answer is same as the last column i have on the snapshot i shared, 102. its not giving the right result either