topic Re: How to calculate a simple sum of [measure] to use in a % of total calculation in DAX Commands and Tips

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

FOXYBARK — Tue, 06 Jun 2023 16:47:22 GMT

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

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

some_bih — Tue, 06 Jun 2023 21:20:49 GMT

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

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

FOXYBARK — Thu, 08 Jun 2023 14:08:17 GMT

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)

)

)