Breaking News: Grepper is joining You.com. Read the official announcement!

dax summarize table with filter

Eager Echidna answered on January 24, 2022 Popularity 8/10 Helpfulness 4/10

answer dax summarize table with filter

dax summarize table with filter

Comment

Order Profile =
CALCULATETABLE (
    SUMMARIZE (
        'Sales Table',
        'Sales Table'[Order_Num_Key],
        Customer[Sector],
        "Total Value", SUM ( 'Sales Table'[Net Invoice Value] ),
        "Order Count", DISTINCTCOUNT ( 'Sales Table'[Order_Num_Key] )
    ),
    YEAR ( DimDate[Datekey] ) = YEAR ( TODAY () )
)

Popularity 8/10 Helpfulness 4/10 Language whatever

Source: community.powerbi.com

Tags: dax filter summarize whatever

Link to this answer
Share Copy Link