Forum Discussion

madji's avatar
madji
Helper I
8 years ago

Measure in PB

Hi I have two questions. This is my Example

 

1. Why Key from Sales and Key from Stock dont have relationshiop

2. How can I get table with calculating

 

 

for measure for stock Ive used this Measure = CALCULATE(Sum('Stock'[Stock]); FILTER( Stock; 'Stock'[Date] = MAX(Stock[Date])))

 

 

I want to get table  

1Product1204
1Product2666

 

 

if  I choose  date1/01 - 2/01

Need Help

5 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    8 years ago

    OK, you are going to need to share some sample data in a form that can be copied and pasted. Too much manual typing to try to recreate this scenario. But note that because of the direction of your relationships, Sales is not going to filter Key or Stock and Sales is not going to filter Product. You probably have to change the directions of your relationships.

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        madji,

        Could you please upload the sample data/PBIX file to OneDrive and post the shared link here? When I try to download the example you post, it is a empty folder.

        Regards,
        Lydia