Forum Discussion

rıdvan's avatar
rıdvan
Regular Visitor
2 years ago

Microsoft dynamics 365 -Power BI

Hello everyone!
I am doing powerbi reporting with Microsoft dynamics. There is an inventory field in the items table. But I cannot see the item variant breakdown of the inventory value. It repeats the value in stock for each breakdown. How can I access this information?

 

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi rıdvan ,

    I'm guessing that the inventory in the table is a measure and it uses "ALL" or "ALLSELECTED".
    If it's a measure, can you provide the DAX? If it's not a measure, it's a problem with the data model, please provide the sample data or the pbix file, thanks!

    Best Regards,
    Dino Tao
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.