cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
donbonbon Frequent Visitor
Frequent Visitor

Something wrong with calculated column (using filtering in it)

Hey,

 

I cannot figure out what is wrong with this formula Column = calculate(DISTINCTCOUNT('DB'[lead_id],FILTER('DB', 'DB'[status]="accepted")))

 

Thnx!

1 ACCEPTED SOLUTION

Accepted Solutions
muchinski Member
Member

Re: Something wrong with calculated column (using filtering in it)

Please, try the following:

Column = calculate(DISTINCTCOUNT('DB'[lead_id]),'DB'[status]="accepted")

 

Explanation: The second part for the CALCULATE is already the filter expression. You don't need to use FILTER in this case. In addition, DISTINCTCOUNT accepts only 1 parameter, so you need to close your parenthesis right after 'DB'[lead_id].

EXTRA TIP: If you want this expression to consider also the other filters applied on you report, you can use the following:

Column = calculate(DISTINCTCOUNT('DB'[lead_id]),KEEPFILTERS('DB'[status]="accepted"))



View solution in original post

5 REPLIES 5
muchinski Member
Member

Re: Something wrong with calculated column (using filtering in it)

Please, try the following:

Column = calculate(DISTINCTCOUNT('DB'[lead_id]),'DB'[status]="accepted")

 

Explanation: The second part for the CALCULATE is already the filter expression. You don't need to use FILTER in this case. In addition, DISTINCTCOUNT accepts only 1 parameter, so you need to close your parenthesis right after 'DB'[lead_id].

EXTRA TIP: If you want this expression to consider also the other filters applied on you report, you can use the following:

Column = calculate(DISTINCTCOUNT('DB'[lead_id]),KEEPFILTERS('DB'[status]="accepted"))



View solution in original post

Re: Something wrong with calculated column (using filtering in it)

You will need to provide more information if you want help. Eg What are you expecting and what are you getting?



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
donbonbon Frequent Visitor
Frequent Visitor

Re: Something wrong with calculated column (using filtering in it)

sorry, I didnt think it was relevant. It just highlights me it in red. I need to count distinct lead_id from table DB where status od this lead_id is accepted

 

 

donbonbon Frequent Visitor
Frequent Visitor

Re: Something wrong with calculated column (using filtering in it)

there is no result, just an error. so I cant understand what is wrong with the sintaxis

donbonbon Frequent Visitor
Frequent Visitor

Re: Something wrong with calculated column (using filtering in it)

it worked, thnx a lot!

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors