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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Referencing values within a table visual (not a data table)

Good day to you all.  This may be in the wrong category, but here goes:

 

  • Have a single data/fact table
  • Have two identical table visuals displaying info from the fact table which are updating based on a set of slicers, except for one visual is not linked to/using one of the slicers.  The result is that the VisualTableA has a "total" view of the data, whereas VisualTableB has the further filtered view of the data.

What I want to do is take the TotalValue for a column from VisualTableA, and divide it by the corresponding/matching column from VisualColumnB.  There are two columns I want to this for, and I am planning on displaying the results in a card  or something along that line.

How can I reference those values in a DAX computation or in some other way?  Or can it even be done? 

Thanks in advance for your guidance.

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Anonymous , No you can not do that, You have to create a measure for that. And if both table are using same slicer with different values using interaction, then you need independent tables too 

 

 

Refer if needed

Compare Categorical Data Using Slicers - Compare two Brands: https://youtu.be/exN4nTewgbc

 

How to use two Date/Period slicers

https://youtu.be/WSeZr_-MiTg

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@Anonymous , No you can not do that, You have to create a measure for that. And if both table are using same slicer with different values using interaction, then you need independent tables too 

 

 

Refer if needed

Compare Categorical Data Using Slicers - Compare two Brands: https://youtu.be/exN4nTewgbc

 

How to use two Date/Period slicers

https://youtu.be/WSeZr_-MiTg

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

Thanks, Amit.... I was afraid of that, but appreciate the pointers!

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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