Inside filter

[gduobaite]

Hello, 

How can I put inside a filter?

I have a few different Event Names and I need to do Clicks' calculations for all of them seperately. 

DAX I have now:

Clicks =
var_table=SUMMARIZE('table1', 'table1'[Doctor], 'table1'[Date time], "name", DISTINCTCOUNT('table1'[Doctor]))
return
SUMX(_table,[name])

What I tried but nothing happened:

Clicks =
var_table=SUMMARIZE('table1', 'table1'[Doctor], 'table1'[Date time], "name", CALCULATE( DISTINCTCOUNT('table1'[Doctor]), 'table1'[Event Name) = "drug_prices_opened"))
return
SUMX(_table,[name])

Event Names I need to implement seperately into formula:

[Fowmy · Accepted solution]

@gduobaite 

Please try your measure like this:

Clicks =
var _name = SELECTEDVALUE('table1'[Event Name])
var _table = 
SUMMARIZE(
    'table1', 
    'table1'[Doctor], 
    'table1'[Date time], 
    "name", CALCULATE( DISTINCTCOUNT('table1'[Doctor]), 'table1'[Event Name] = _name)
)
return
SUMX(_table,[name])

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[gduobaite]

Dear @Fowmy , 

can you please show how can I add a second filter into this formula?

Second filter should be from the same table1: 'table1'[Search Result] = "Not found"

Clicks =
var _name = SELECTEDVALUE('table1'[Event Name])
var _table = 
SUMMARIZE(
    'table1', 
    'table1'[Doctor], 
    'table1'[Date time], 
    "name", CALCULATE( DISTINCTCOUNT('table1'[Doctor]), 'table1'[Event Name] = _name)
)
return
SUMX(_table,[name])

[Fowmy]

@gduobaite 

Please check this:

Clicks =
var _name = SELECTEDVALUE('table1'[Event Name])
var _table = 
SUMMARIZE(
    'table1', 
    'table1'[Doctor], 
    'table1'[Date time], 
    "name", CALCULATE( DISTINCTCOUNT('table1'[Doctor]), 'table1'[Event Name] = _name, 
    'table1'[Search Result] = "Not found")
)
return
SUMX(_table,[name])

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[gduobaite]

@Fowmy you are today's hero. 🙂

Thank you.

[gduobaite]

@Fowmy , awesome! Thank you!