slicer with measure
1 Topic
dynamically Data from Two table using slicer in card
Dear All, I am very new in power BI therefore need a favour in dax, Please help me to create a Dax, I have two data sets table 1 & table 2 as given below. The requirement is total sales USD 2000 from table 1, but when we use slicer for counry values should be pick up from table 2. i.e Canada 500, Russia 200 and Germany 300. Please help me to get this in a card in power BI. Table 1 Table 2 Country name Sales Country Sales USA 690 Canada 500 India 780 Russia 200 Canada 340 Germany 300 Russia 30 Germany 160 Total Sales 2000Solved955Views0likes4Comments