Microsoft dynamics 365 -Power BI

[rıdvan]

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?

[Anonymous]

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.