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!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
I have a Power BI report that is using multiple tabs from Excel for different reporting purposes.
Column A and B are in the same Tab "A", C is in another tab "B". They are connected in the Data Model with a key column. I need a way to display if in Tab"B" the Workbook names count equals the Workbook count from Tab "A". For instance, Tab "A" Red workbooks, There are 54, in Tab "B" If there are 54 Red Rows, I need the Column or Measure to say something, like Complete. Is this even possible???????
Yes, certainly sounds possible with something like a COUNTROWS(RELATEDTABLE('B') but tough to say exactly. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490