FIXED in POWER BI to get the level of detail

[Dhruv100322]

I have the following dataset in power BI:

ID	Name		Type		Channel		Frequency		Open
1	Message 1		A		B		C		10
2	Message 2		A		B		C		20
3	Message 3		B		A		C		40

I am trying to get the following table in Power BI as a result:

ID	Name		Fixed Open
1	Message 1		30
2	Message 2		30
3	Message 3		40

Fixed Open is calculated as the group of Type, Channel and Frequency so it will be like below:

Type		Channel		Frequency		Open (SUM)
A		B		C		30
B		A		C		40

How can I achieve this in Power BI?

[FreemanZ]

try to create a table with this:

Table =

VAR _table =

ADDCOLUMNS(

    TableName,

    "OpenSum",

    CALCULATE(

        SUM(TableName[Open]),

        ALLEXCEPT(TableName, TableName[Type], TableName[Channel], TableName[Frequency])    

    )

)

RETURN

SELECTCOLUMNS(

    _table,

    "ID",TableName[ID],

    "Name", TableName[Name],

    "OpenSum", [OpenSum]

)

i tried and it worked like this:

[tamerj1]

Hi @Dhruv100322 
Please try

Fixed Open =
CALCULATE ( SUM ( 'Table'[Open] ), ALLEXCEPT ( 'Table', 'Table'[Type] ) )

[Dhruv100322]

it doesnt work. it gives as below 

[tamerj1 · Accepted solution]

@Dhruv100322 
Please refer to attached sample file with the solution

Fixed Open = 
CALCULATE ( 
    SUM ( 'Table'[Open] ), 
    ALL ( 'Table' ), 
    'Table'[Type] = MAX ( 'Table'[Type] ) 
)