The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
User | Count |
---|---|
11 | |
8 | |
6 | |
6 | |
6 |
User | Count |
---|---|
23 | |
14 | |
13 | |
10 | |
8 |