Ignore Top 10 on measure

[NewbieJono]

could anyone help with this issue

[jdbuchanan71 · Accepted solution]

You are going to have to use a measure rather than the 'Display as %' option.   If there are 2 items that you need to not consider in the total it would be something like this.

Percentage =
DIVIDE (
    SUM ( YourTable[Expense] ),
    CALCULATE (
        SUM ( YourTable[Expense] ),
        ALL ( YourTable[Description] ),
        NOT ( YourTable[Description] IN { "Excluded Description 1", "Excluded Description 2" } )
    )
)

[jdbuchanan71]

Yep, you need both the exclusion in the measure to take care of the denominator and the filter on the visual to take care of the numerator.

[NewbieJono]

sorry i dont feel like i am explain myself very well. Here is a snapshot of my tables.  i have blanked out some sensitive info.

the issue is when i apply the top 10 inbuilt filter. The percentage is also not a mesure it is just selecting the display as a percentage option. The second image show how the Percentage changes to percentage of the top 10

To make things a but more complicated, in desctiption i do need to filter out two items, which i currently do on the filter pane.

[jdbuchanan71]

@NewbieJono 

Try writing your Percentage measure like this.

Percentage =
DIVIDE (
    SUM ( YourTable[Expense] ),
    CALCULATE ( SUM ( YourTable[Expense] ), ALL ( YourTable[Person] ) )
)

[jdbuchanan71 · Accepted solution]

You are going to have to use a measure rather than the 'Display as %' option.   If there are 2 items that you need to not consider in the total it would be something like this.

Percentage =
DIVIDE (
    SUM ( YourTable[Expense] ),
    CALCULATE (
        SUM ( YourTable[Expense] ),
        ALL ( YourTable[Description] ),
        NOT ( YourTable[Description] IN { "Excluded Description 1", "Excluded Description 2" } )
    )
)

[NewbieJono · Accepted solution]

thanks for your reply. the percentage displays correct when using this code, but then i apply top 10 filter to description it still has the same issue

Percentage1 = 
DIVIDE (
    SUM ( 'FACT - Error Data'[ALL]),
    CALCULATE (
        SUM ( 'FACT - Error Data'[ALL] ),
        ALL ( 'FACT - Error Data'[DESCRIPTION]),
        NOT ('FACT - Error Data'[FAILURE REASON] IN { 51, 52 } )
    )
)

[NewbieJono]

I Think i got this working with your code, but it the chart was still including codes 51, 52. but when i addded a filter to exclude these it seemed to work. is this correct method? thanks for your help

TOP10 PERCENTAGE = 
DIVIDE (
    SUM ( 'FACT - Error Data'[ALL]),
    CALCULATE (
        SUM ( 'FACT - Error Data'[ALL] ),
        ALL ( 'FACT - Error Data'[DESCRIPTION]),
        NOT ('FACT - Error Data'[FAILURE REASON] IN {51,52 } )
    )
)

[NewbieJono]

how could i mofify this so i can not ignore one of my filter?

Percentage =
DIVIDE (
    SUM ( YourTable[Expense] ),
    CALCULATE ( SUM ( YourTable[Expense] ), ALL ( YourTable[Person] ) )
)

[NewbieJono]

The issue i provided is not my example but similar. The above does not work for me, i 

i work out my percentage like this

Daily Percentage Failure Rate = [Total Failures] / [Total Transactions]

The Dax For Total Failures is:

Total Failures =

VAR

TOTALFAIL = CALCULATE (

SUM('FACT - Error Data'[ALL]),

FILTER('FACT - Error Data','FACT - Error Data'[FAILURE REASON]<> 51 && 'FACT - Error Data'[FAILURE REASON]<> 52)

)

RETURN

TOTALFAIL

The dax for total transactions is

Total Transactions =

VAR

totalIntefrity = CALCULATE (

SUM('FACT - Integrity Data'[VOLUME]),

filter('FACT - Integrity Data','FACT - Integrity Data'[CODE]="TTE.02")

)

VAR

totalError = CALCULATE (

SUM('FACT - Error Data'[ALL]),

FILTER('FACT - Error Data','FACT - Error Data'[FAILURE REASON]= 51 || 'FACT - Error Data'[FAILURE REASON]= 52)

)

RETURN

totalIntefrity - TotalError