cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper III
Helper III

Inside filter

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:

gduobaite_0-1601489789556.png

 

1 ACCEPTED SOLUTION
Community Champion
Community Champion

@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

View solution in original post

5 REPLIES 5
Community Champion
Community Champion

@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

View solution in original post

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])

 

 

Community Champion
Community Champion

@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

@Fowmy you are today's hero. 🙂

Thank you.

@Fowmy , awesome! Thank you!

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors