Forum Discussion
Dax measure help
Hi SilentEagle ,
Can you please confirm what you are using Power BI or Excel?
Community SupportHi SilentEagle ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.
Hi v-menakakota,
Thanks for your help and apologies for the delay. I tried your suggestion with using "Related" function but I get an error saying that the entity column doesn`t either doesn`t exist or doesn`t have a relationship to any table availabe in the current context. I also tried to use the entity column of the mapping table instead of the cost (BDG) table but I got the same error. Both cost and net sales tables have a relationship on the entity with the entity mapping table so not sure why it doesnt work.
- v-menakakota
Hi SilentEagle ,
Can you please provide the details of model view or screenshot it would be easy to figure out.
Thank you.Hi v-menakakota ,
Sure, please see below the relationsips and the pivot output. For some reason the % split that is calculated in this sample file through the allocated cost is wrong but in my actual working file it`s correct so you can ignore that. In the 2nd screenshot you can see that with the last shared formula I can only see the allocation if I use the BDG entity column (even though the % is wrong here). If I replace the entity column from BDG table to mapping table in the measure now I can see the allocated cost but it`s not split out, it`s duplicated instead. Also the measure where I tried the previously suggested "related" function is in error.
Many thanks
- v-menakakota
Hi SilentEagle ,
It can be due to uni directional filter. If we can make the relation between Mapping and cost table as bi-directional then will be able to see the values i guess. Can you try it ones and check.
Thank you and Regards,
Menaka.