Forum Discussion

Alice_BI's avatar
Alice_BI
Frequent Visitor
3 years ago

How to count rows in a Power BI table visual with multiple filters?

hi guys, Please please Help    I have a seemingly easy problem that takes one click to fix in Excel but in Power BI this is unnecessarily complicated.   I have a simple Power BI table visual that...
Need Help
Tips and Tricks
YukiK's avatar
YukiK
Icon for Impactful Individual rankImpactful Individual
3 years ago

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

Alice_BI's avatar
Alice_BI
Frequent Visitor
3 years ago

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?