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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
tanveal
New Member

table visual in powerbi

Hello, 

 

Is there way to perform calculations on the visuals rather than creating a measure or calculated column ?

I want to multiply price with tradeable QTY in the below visual, both columns are coming from different tables and SEC-ID is not unique in either so I cannot create 1-to many relationship (it's always many to many) so I cannot use Related function to connect two tables.

Just trying to think if there is workaround. Thank you

 

tanveal_1-1684420597074.png

 

2 REPLIES 2
tanveal
New Member

thanks Kishore, can you please give me example of the DAX formula I can use, lets say the column "TradebleaQTY" is in "QTY" table and column price is in "Price" table. If the values are indeed unique for each sec ID, how would the formula display ? Thank you 

Kishore_KVN
Super User
Super User

Hello @tanveal eventhough there is many to many relationship if you can confirm the values will be unique for each sec-ID then you can use 'LOOKUPVALUE' to get the details from another table. 

 

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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