Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I have problem to apply more than one filter (<filter2>....) to my FILTER and CALCULATE functions using the equal "=" operator. They only take the first filter but not the subsequence filters.
To make it work I had to go opposite way using multiple no equal "<>" operator which make my programme very long. Instead of saying I want to keep 2 things out of 20, now I have to say remove 18 things out of 20.
CALCULATE(<expression>,<filter1>,<filter2>…)
FILTER(<table>,<filter1> && <filter2>) or FILTER(<table>, AND(<filter1>, <filter2>)
I working with the latest April 2019 Power BI Desktop version. I am still learning DAX but logic tell me if it can take multiple "<>" conditions it should take multiple "=" conditions and other multiple of other operators.
Please help.
Solved! Go to Solution.
Hi @Jeff_Ng,
The filter conditions in CALCULATE(<expression>,<filter1>,<filter2>…) are performed with AND operation.
You can modify the Calculate_2 as below:
Best Regards,
Qiuyun Yu
Hi @Jeff_Ng,
I have modified the measure below:
hi @v-qiuyu-msft ,
Not quite. I,m expecting Calculate_2 is equal to Calculate_4 which is 34 in all rows. Similarly SumX_2 = SumX_4, and SumX_3 = SumX_5.
In fact my concern is not about the results. I want explaination why multiple filters with "=" operators not working in Case 1 but multiple filters with "<>" operators worked in the Case 2.
Sybtax for CALCULATE(<expression>,<filter1>,<filter2>…)
Hi @Jeff_Ng,
The filter conditions in CALCULATE(<expression>,<filter1>,<filter2>…) are performed with AND operation.
You can modify the Calculate_2 as below:
Best Regards,
Qiuyun Yu
Hi @Jeff_Ng,
If the report doesn't contain any sensitive data, you can upload it to your OneDrive and paste the share link here.
Best Regards,
Qiuyun Yu
Hi @v-qiuyu-msft ,
Thanks for taking time to response. Attached is the pbix file with ficticius data with some of my measures explaning the problems I mentioned above.
Please explain why "=" operator is not working in measures
ohh..How do I attach file?
Hi @Jeff_Ng,
Is it possible for you to share a pbix file to clarify the issue? Please remove sensitive data in the report before you share it.
Best Regards,
Qiuyun Yu
User | Count |
---|---|
123 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
183 | |
90 | |
67 | |
62 | |
53 |