Forum Discussion

AnthonyH28's avatar
AnthonyH28
Helper I
5 years ago

Measure changing when column added to matrix

This inquiry is to understand why this measure is being affected by another column being added. I have a list of products with measures for Past Year, Past YTD, YTD and YTD Growth for sales - pret...
Need Help
AnthonyH28's avatar
AnthonyH28
Helper I
5 years ago

The related worked in that it brought in the right information, but that measure still lists everything as 100%.

Here is the model

 

  • AnthonyH28's avatar
    AnthonyH28
    Helper I
    5 years ago

    Let me reclarify, my last statement I crossed my words.


    DIM_Products is my sku level table, about 17,000 skus or so. The Table that has the Percent of Company (DIM_Products%Company) is the much smaller table, as we have about 60 products. Those 60 get updated every day with a new % figure in their corresponding field in their row.

    I brought the column over from DIM_Products%Company to DIM_Products using Related but the issue persists.

    I supposed this actually would be easy enough to just replicate the RELATED function in SQL before the data is ingested into PBI, which solves my relationship problem because I can just get rid of that table all together. But I still am interested how to fix it in PBI.

    EDIT: I did just that. I recreated the RELATED function in SQL since I could not get it to work properly in PowerBI. If someone has the right solution, I will update this with that information. I welcome a PowerBI fix since this didnt really feel like it needed to be solved in SQL but I did.