SUM total days Commission then list all days over budget

[ProductOwnerMI]

Hi all,

My data is in a Cube and im using PowerBI as the reporting tool.

I would like to SUM commission by day and then identify the days over budget.

1. Currently commission is stored per trasnaction - therefore need a function to sum total for the day

2. the Budget number is not stored in the DB so would be a static value

I would like to display in a table:

1. For the days over budget (>10,000)

Date - Total commission for the day

2. COUNT of the days over budget in a given period (i.e YTD)

Thanks for any help   

[v-easonf-msft]

Hi,  @ProductOwnerMI 

Not fully sure what is your question, can you elaborate a bit more?

Please share you sample data for further research.

Best Regards,
Community Support Team _ Eason

[amitchandak]

@ProductOwnerMI ,You can try a measure like

Make sure you have budget and commission  measures

countx(filter(Values(Date[Date]), [commission] >[Budget]))