Custom summarization of a table

[adi1234]

I have a table that looks like this:

                 fig(1)

When i import the table in powerbi the summarization is set by default and the table is summarised in the following way.

                  fig(2)

I have a requirement that when i summarise the table it should be in the following manner:

ie. when the value in F1=0, it should skip that whole row for summarisation. How can the summarisation take place.

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

It is for creating a new table.

New Table =
UNION (
    GROUPBY (
        FILTER ( Data, Data[F1] <> 0 ),
        Data[Item],
        "@F1", SUMX ( CURRENTGROUP (), Data[F1] ),
        "@F2", SUMX ( CURRENTGROUP (), Data[F2] ),
        "@F3", SUMX ( CURRENTGROUP (), Data[F3] )
    ),
    FILTER ( Data, Data[F1] = 0 )
)