Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

Dax Measure or Calculated Column, can this be done??

I have a Power BI report that is using multiple tabs from Excel for different reporting purposes. Power BI help.PNG

 
 
 

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???????

1 REPLY 1
Greg_Deckler
Community Champion
Community Champion

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



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.