Applying filters to get counts same as in excel

[ghouse_peer]

Hi Team,

I have 3 columns Date, Impacted, Status

Date columns have dates from 2020 to till date

Impacted column has Yes/No values

Status column has Inprogress and completed.

Requirement: i need to get count, upon applying filter on impacted column as "Yes" and Status should be "Completed"

whatever count we get divide that by same count which we got by appying this filter and show in percentage.

for ex: After applying filter we got the count as 11, now divide 11 by 11 and show in percentage.

Please help me with this solution/measure

[v-xiaotang · Accepted solution]

Hi @ghouse_peer 

Please try this, 

Measure = 
var _status= "completed"
var _Impacted="Yes"
return  CALCULATE(COUNTROWS('Table'),FILTER('Table','Table'[Impacted]=_Impacted && 'Table'[Status]=_status))

result

Best Regards,

Community Support Team _Tang

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