topic Re: FIXED in POWER BI to get the level of detail in DAX Commands and Tips

FIXED in POWER BI to get the level of detail

Anonymous — Mon, 05 Dec 2022 11:57:12 GMT

I have the following dataset in power BI:

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

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

How can I achieve this in Power BI?

tamerj1 — Mon, 05 Dec 2022 12:09:26 GMT

Hi Anonymous
Please try

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

Anonymous — Mon, 05 Dec 2022 12:16:13 GMT

it doesnt work. it gives as below

FreemanZ — Mon, 05 Dec 2022 13:01:05 GMT

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 — Mon, 05 Dec 2022 13:26:57 GMT

Anonymous
Please refer to attached sample file with the solution

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