Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have two tables in the linked example below. The first table accurately displays the target value that I want and expect for each product.
The second table displays the avg quantity sold for each product. I would like to display the target value next to the avg quantity sold. But I don't get the expected value for target on the second table. The expected value is the target on this first table.
Can you help?
https://drive.google.com/open?id=11vzlQW0WF1g2jUvmLJNlPgNm3AGdcs7U
Solved! Go to Solution.
Thanks for the sample file, makes everything a lot easier
Is this what you were looking for ?
when you see a column returning all the same value it usually indicates some problem with the filter context
I wrote a measure to store the value of the current product, then use that value to lookup the target direct from the target table
I'm a personal Power Bi Trainer I learn something every time I answer a question
The Golden Rules for Power BI
Help when you know. Ask when you don't!
Thanks for the sample file, makes everything a lot easier
Is this what you were looking for ?
when you see a column returning all the same value it usually indicates some problem with the filter context
I wrote a measure to store the value of the current product, then use that value to lookup the target direct from the target table
I'm a personal Power Bi Trainer I learn something every time I answer a question
The Golden Rules for Power BI
Help when you know. Ask when you don't!
@kentylerthat's it! thank you!
Boy do I still have a lot to learn when it comes to DAX and measures. Got to start studying up on the VAR function.
thanks again.
depending on how your head works... take a look at the free lessons and other material on sqlbi.com
or look at avi sing's learnpowerbi videos on youtube
or search on youtube for curbal
Help when you know. Ask when you don't!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
116 | |
101 | |
74 | |
70 | |
47 |
User | Count |
---|---|
146 | |
107 | |
106 | |
89 | |
65 |