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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
BerryRogers
Regular Visitor

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

@BerryRogers , 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

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@BerryRogers , 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

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors