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

DAX: count with two filters

When I type this formula with one filter in Power BI it gives right number:

 

agreed= CALCULATE(COUNT(DB[Status]),FILTER(DB,DB[Status]=28))

 

But, when I type same formula with two filters it shows (Blank):

 

agreed= CALCULATE(COUNT(DB[Status]),FILTER(DB,DB[Status]=28 && DB[Status2]=30))

 

Could you please help me in solving this problem. What is right DAX formula for calculating number of two conditions from same column (in this case 28 and 30)?

 

Thanks!

 

2 REPLIES 2
Evelyn Frequent Visitor
Frequent Visitor

Re: DAX: count with two filters

Thank you for the feedback, Natavan!

Can you please tell us which country/language you are using?

We will be investigating this issue and will get back to you.

natavan Frequent Visitor
Frequent Visitor

Re: DAX: count with two filters

Capture.PNG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Dear Evelyn,

 

I use BI desktop as English (US) from Azerbaijan.

Helpful resources

Announcements
New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (2,967)