Forum Discussion
How to count rows in a Power BI table visual with multiple filters?
I've done this at work once. It's a lot more work than it seems. You need to create a virtual table that contains any table/column and do COUNTROWS() over it.
Something along with this will work:
Your Measure =
COUNTROWS(
SUMMARIZE(
Sales,
Customer[name],
Customer[Address],
etc
)
)Thank you Yukik!
I'm almost there and i found the culprit:
Coutrows(Summarize(Sales Fact, Custumer Dim[Name],Business Dim[Name],Orders Dim[ID] etc.. ))
This almost works but im missing 2 rows , i couldn't include the Client address column in the Summarize table above because it's a snowflake dimension from the main client dimension.. How do i include it?
That should. Assuming those dim tables have a relationship the fact table. At least this is how I got around it I believe. It's basically trying to create the same DAX code as the visual produces if that makes sense
One of the fields from the client addresses dimension included in the table visual does NOT have a relationship to the fact table. It's a snowflake from another dimension. That's why im missing 2 records. Any idea how to include it?
