Forum Discussion
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
Super UserIf they are in same table you can use
column = [sales]* [percent]
measure = sumx(Table,Table[sales]* Table[percent])
- amitchandak
Measure 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