Sum from others table by date & enum filter

Dear all experienced,

I am trying to make an app, Now I am suffering a problem,

It’s a sales app, I am doing it for 3 branches & every branch has 2 types of sales like Branch sales & online sales.

Now I am trying to generate a report between date on depends on sales type (like Branch & Online) and all means both sales also.

So I used below formula for the report & its working on branch & online, But I need more that will be for (sum of Branch & Online) & it will be shown when I click on (All) button,

How can I write the formula, Pleeease help me…

SUM(SELECT(Jaudat Jamuna[Burger],and([Date]>= [Start Date], [Date] <= [End Date],[Order From]=[Order Type])))


0 2 116
2 REPLIES 2
Top Labels in this Space