Forum Discussion
Dax measure help
Hi SilentEagle ,
Can you please confirm what you are using Power BI or Excel?
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
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.
Hi 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 SilentEagle ,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
Hi v-menakakota ,
No, I havent resolved it yet. I believe the bi-directional relationship only works in Power Bi not Excel. I`ve tried multiple measures and filters but still no luck.
Thanks for your help though!