This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowJuly 28 - August 9 | Final Round of the Power BI Dataviz World Championships. This is your chance. Learn more
Hey team,
I am trying to get count of id on basis of three filters. Where first filter is "renewal" applied on column charging mode, the second filter is "1" on status column and third filter is on "ft" on source id column. The problem I am having is that if the filter of charging mode and source id are not working together. Like if i select charging mode "renewal" just few values show on the source id column. What is this issue?
filters are applied on top of each other ("AND"). If you expect a different behavior then you need to use measures (and likely disconnected tables)
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
If you love stickers, then you will definitely want to check out our community sticker challenge, Barcelona edition!
Check out the July 2026 Power BI update to learn about new features.