Sample card filtered percentage of column total

[abosan]

Hello, total noob here.

I tried to search, but I'm so new that I'm not sure of the right terms to look for. As a result, none of the answers I found fit my stage.

Here's an example of the data I'm working with:

TransactionID	Transaction value	Status of the transaction
123	$100	1
456	$300	1
789	$50	2

What I would like to calculate is the value of transactions with a status of 1 as a percentage of the total sum of transaction values.

In this example, the correct answer must be 89%.

Can someone point me in the right direction?

[v-gizhi-msft · Accepted solution]

Hi,

try this:

Measure = CALCULATE(SUM('Table'[Transaction Value]),FILTER('Table','Table'[Transaction Status]=1))/SUM('Table'[Transaction Value])

The result shows:

Best Regards,

Giotto Zhi

[amitchandak]

@abosan ,

Try

Measure = 
divide(
calculate(sumx(Filter(Table,Table[Transaction Status] =1 ),Table[Transaction Value])),
calculate(sum(Table[Transaction Value]),ALL(Table))
)
OR
Measure = 
divide(
calculate(sumx(Filter(Table,Table[Transaction Status] =1 ),Table[Transaction Value]),ALLEXCEPT(Table,Table[Transaction Status])),
calculate(sum(Table[Transaction Value]),ALL(Table))
)

[az38]

Hi @abosan 

try a measure

Measure = 
DIVIDE(
CALCULATE(SUM('Table'[Transaction Value]),ALLEXCEPT('Table','Table'[Transaction Status])),
CALCULATE(SUM('Table'[Transaction Value]),ALL('Table'))
)