How to divide a value of a column dynamically based on date and the count of another column

[Anonymous]

Hello,

I am trying to divide the "Budget per channel" for the channel "Distant Sales - E-shop - Web with delivery". I want to divide it per number of Stores (1,2,3 etc) per day in order not to have always the Total Budget for all stores for all days of the selected date range, displayed for the channel "Distant Sales - E-shop -Web with

delivery" when I drill down to stores. 

Is there any way to do that?

Notes.

a. The number 4.270.881 is the Budget for all stores for the selecte date range for the "Distant Sales - E-shop - Web with delivery".

b. I have calculated the measure "Budget by channel" with a switch statement where I add the Budget for the different channels (E-shop etc) from different tables, that is way it is working for other channels.

Thank you!

[V-lianl-msft · Accepted solution]

Hi @Anonymous ,

You can calculate the number of stores in the selected date, then divide your calculated measure by the number of stores.

The measure may like below:

measure =
var stores_ = CALCULATE (DISTINCTCOUNT (Sales[store]),ALLSELECTED ('Date'[Date]))
return DIVIDE ([your measure],stores_)

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