Forum Discussion
Filter by column in underlying data
td48260 not sure what you mean using type on the slicer will throw the count off
just use type and year as a slicer and a simple measure
Count = COUNTROWS ( Table )or maybe I didn't understand your question, explain it with sample data if that is the case.
✨ Follow us on LinkedIn and to our YouTube channel
Check my latest video on Filters and Sparklines https://youtu.be/wmwcX8HvNxc
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.
td48260 yes this functionality is out of the box, seems like you are overcomplicating it.
Simple question, if you have years on rows, count rows on value, and slicer by type A what do you get? You should get the correct result.
Maybe I'm missing here something obvious.
Yes, I was overcomplicating it! Once I removed the GROUP BY operation and added a Measure COUNTROWS(Table), it works.
Thanks for your patience and help!
Tim