The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 |
---|---|
16 | |
8 | |
6 | |
6 | |
5 |
User | Count |
---|---|
23 | |
13 | |
13 | |
8 | |
8 |