Calcualte Sum(Price) Ignoring one level

Question

I need to create a measure which will group by vendorname and account name and pick max price and sum price at vendor level and account level ignore subaccount level.

Create Derived table as shown in excel and do sum of price on derived table
Example V1 has 2 accounts V1 Price is 30 Sum(Price)
Example V1 A1 Leve has 2 Sub accounts but even though it has 2 subaccounts consider 10 and calculate final measure

Basically ignore subaccount level and sum at other levels.

Answer 1

Hi,
Are you talking about a OLAP MDX measure or a Tabular DAX measure here ?