Get percentage using filter

[Anonymous]

Hi, 

I am trying to calculate % using the filter function

it is just count(Opened)/sentable[sentCount]

I have already calculated an OpenTotal measure, but I cannot this is on the % calculation, it is not showing up.

OpenTotal = CALCULATE(
count(ActivityTable[leadId] ),
FILTER( ActivityTable, ActivityTable[activity] = "opened") )

[v-yalanwu-msft · Accepted solution]

Hi @Anonymous 

Maybe you put the closing bracket incorrectly，and you could modify your measure by the following formula：

OpenTotalRate1 =
DIVIDE (
    CALCULATE (
        COUNT ( 'ActivityTable'[Product] ),
        FILTER ( ALL ( 'ActivityTable' ), 'ActivityTable'[activity] = "opened" )
    ),
    'sentable'[sentCount]
)

Or

OpenTotalRate2 =
COUNTX (
    FILTER ( ALL ( 'ActivityTable' ), 'ActivityTable'[activity] = "opened" ),
    'ActivityTable'[leadId]
) / 'sentable'[sentCount]

In addition, If sentable[sentCount] is a column (only one counted number),you could change 'sentable'[sentCount] to VALUES('sentable'[sentCount])

The final output is shown below:

Best Regards,

Yalan Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ashish_Mathur]

Hi,

This measure can be simplified to

OpenTotal = CALCULATE(count(ActivityTable[leadId]),ActivityTable[activity] = "opened")

Not sure of what the SentTable is