Hey Guys,
Thank you for this awesome course!! I have never learnt so much from doing a Power BI course than this course. I was following along with the example from the course and reached Lesson 81 - Advanced Filtering and Branching in DAX. I was working on the Transaction w/Low Inventory Dax Measure and was able to replicate it and understand the logic perfectly as to what is trying to be achieved. Only problem is I get on results when doing this measure. Sam got results and I cannot work out how he got the results. ie I cannot replicate it first in Excel or in Power BI. I have tried many different things!! I tried to do the formula without using branching measures. ie I tried doing it by using the actual columns from the tables and trying to reproduce the results for each part but I get the same result nothing comes up. I tried some other calculations using firstly all the same tables in a DAX measure so I did a count of transactions based on something else from the Sales table and I get results for this. But when I try another DAX measure using measures from the Sales and Inventory tables I get no results so its making me think it may be a Relationship issue. I checked all the relationships I have and they match the relationships from the worked example as per what Sam had.
I was able to open the completed file that comes in the resources pack and was able to bring in the Transactions w/Low Inventory measure and it works perfectly. So I am lost I cant figure out why it will not work on my file I created.
I did not use any templates or anything that came in resource pack, apart from the background to make it look like the template file Sam was using. All other things I did manually, including the Date table and all the measures and measure folders and the original measures table to create the placeholder for where the measures and sub folders will be stored.
I am absolutely loving this course and doing the material and trying to replicate it with real life stuff where I can. I hope that someone can help me with this issue and please explain to me the reasoning behind how the measure in question works and how the transaction numbers for each stock code are arrived at, because I have no idea how to replicate this and to reason it out in my head. eg Item No. STK-100 has 121 transactions in the Sales table. The Total Value in the Inventory table for STK-100 is 7740. But in Sams example this measure returns 11 for Total Value > 50000. But dont these belong to other Item Numbers?? How can STK-100 have 11 transactions that relate to a Total Value of over 50000??
Beginner Guide To Power BI Demo_v1.1.pbix (727.5 KB)
Thanking you all in advance and keep up the good work.