How to calculate a simple sum of [measure] to use in a % of total calculation

[FOXYBARK]

Hi. 

I would like to have a calculation to show my total sum of [Daily Badge Counts] (168431). My attempt to show this is in my [test2] calc below. [Daily Badge Counts] is a measure. Ultimately, I want to calc a % of grand total. 

I have the following table to show my existing data. 

Here is my [test2] meaure. 

test2 = CALCULATE(

[Daily Badge Counts],

all(Badge[BADGE_SCAN_DAYOFWK_TXT]))

Daily Badge Counts = CALCULATE(DISTINCTCOUNT(Badge[Badge&Date ID]))

Thanks

[some_bih · Accepted solution]

Hi @FOXYBARK , try measure

test2=

DIVIDE([Daily Badge Counts],

    CALCULATE(

        [Daily Badge Counts],

        ALL(SHEET17)

    )

)

SHEET17 replace with your table name. I hope this help

[FOXYBARK]

Thank you. I ended up using the ALLSELECTED to accomodate my data. But it works. 

test2=

DIVIDE([Daily Badge Counts],

    CALCULATE(

        [Daily Badge Counts],

        ALLSELECTED(SHEET17)

    )

)