Help getting stacked data divided by unstacked totals

[kqrb75]

Hi, I'm trying to divide different brand totals from a stacked dataset by unstacked totals of store numbers from a different dataset. Can someone help? Is there an easy dax for this? For example, I could have 1500 recommendations for Minute Maid Orange Juice on one stacked dataset and would like that number to be divdied by the number of grocery stores I called over all on an unstacked dataset.

[v-yulgu-msft]

Hi @kqrb75,

From current description, it's hard to imagine your scenario. Please post sample data to make the table structure and detailed values more clear. Also, show us your desired output. How do you want to visualize dataset? If possible, illustrate it with an image.

Regards,

Yuliana Gu

[Greg_Deckler]

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490