Forum Discussion
GARMAS97
6 years agoRegular Visitor
DATA MODEL - ENTERING DATA MANUALLY
Hi guys! I have a concern with the data that I've entered to my BI dashboard. First of all, all the sales from every supplier are on the software already, also, i've entered the data manually by ...
amitchandak
Super User
6 years agoIf they are in same table you can use
column = [sales]* [percent]
measure = sumx(Table,Table[sales]* Table[percent])
amitchandak
Super User
6 years agoMeasure in same table
measure = sumx(Table,Table[sales]* Table[percent])
Measure across tableyou need common context refer : https://community.powerbi.com/t5/Community-Blog/Decoding-Direct-Query-in-Power-BI-Part-2-Date-Difference-Across/ba-p/934397#M451