Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi Guys.
I'm stuck and can't get free.
Model below with dynamic columns.
https://drive.google.com/file/d/1bAEMtI30Nq1TT6fVzie9WLCYzwtoGiJV/view?usp=sharing
Varying the month, the activities get planned, started, finished, change.
At first I wanted just like Count Results from a Measure.
I solved it by creating 3 measures, with Measure F = COUNTROWS(FILTER('TP',[#Dynam Status] = "Finished")). And putting the 3 in Pie.
I thought, this solves it...while in Pie Grafic I noticed a problem.
It has the count, but it has no link with the table.
I would like to click on a status in the Pie Chart and it filters out all the activities for that Status.
Thanks!
Solved! Go to Solution.
https://community.powerbi.com/t5/Desktop/Count-Results-from-a-Measure/m-p/2535592/highlight/true#M89...
I asked the similar question, but incompletely, the same was answered for me.
https://community.powerbi.com/t5/Desktop/Count-Results-from-a-Measure/m-p/2535592/highlight/true#M89...
I asked the similar question, but incompletely, the same was answered for me.
You can avoid all these issues (and measures) by bringing your source data into a better format.
Instead of
you will want to use
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!