I want different results in the same row

[eoshila]

I have 3 data tables for 3 branches “Jaudat Jamuna”, “Paddo Priol”, “Bihot Bazar”

And I want to write one formula in a row for showing 3 different tables results in the same row.

Like when I select (Branch = “Jaudat Jamuna”) below formula will work
Sum(Select(Jaudat Jamuna[Sub],and([Branch]=“Jaudat Jamuna”,[Date]=[_THISROW].[Date])))

Like when I select (Branch = “Paddo Priol”) below formula will work
Sum(Select(Paddo Priol[Sub],and([Branch]=“Paddo Priol”,[Date]=[_THISROW].[Date])))

Like when I select (Branch = “Bihot Bazar”) below formula will work
Sum(Select(Bihot Bazar[Sub],and([Branch]=“Bihot Bazar”,[Date]=[_THISROW].[Date])))

How to marge those 3 formual
Please help me

[WillowMobileSys · Accepted solution]

I will assume that “THIS” table is a 4th table where you select the Branch name and a Date and then are shown a summed result for that Branch. I will call this summed column [Result] since I am not sure what exactly you are summing.

You will want to use an expression like below placed into the App Formula of this [Result] column:

SWITCH([Branch],
    “Jaudat Jamuna”, Sum(Select(Jaudat Jamuna[Sub],and([Branch]=“Jaudat Jamuna”,[Date]=[_THISROW].[Date]))),
    “Paddo Priol”, Sum(Select(Paddo Priol[Sub],and([Branch]=“Paddo Priol”,[Date]=[_THISROW].[Date]))),
    “Bihot Bazar”, Sum(Select(Bihot Bazar[Sub],and([Branch]=“Bihot Bazar”,[Date]=[_THISROW].[Date]))),
    0
)

The final zero (0) is a default and only assigned of the selected branch name is not know in this expression.

[eoshila]

If I want to sum more items like [Sub]+[FS Sub]+[Club]
Then how can I write the formula
Please

[WillowMobileSys]

eoshila:

If I want to sum more items like [Sub]+[FS Sub]+[Club]
Then how can I write the formula

I don’t understand the issue.

Assuming that [Sub], [FS Sub] and [Club] are 3 comuns you want to add together, then what you have written IS the expression. [Result] =:

[Sub]+[FS Sub]+[Club]

[eoshila]

@WillowMobileSystems

Thanks, Thanks & Thanks

It’s Working and I learned.

This cooperation of yours prevents wasting my time in future