Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
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.
Dear Evelyn,
I use BI desktop as English (US) from Azerbaijan.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.