Forum Discussion

kang990's avatar
kang990
Frequent Visitor
2 years ago

Summarize table with zero

Hello, I have two tables as below:   Sales Salesperson Date Category AAA 2023-01-02 BAT BBB 2023-03-03 TGA AAA 2023-03-03 TGA BBB 2023-03-03 TGA CCC 2023-04-23 BAT ...
"DAX"
Power BI Desktop
ThxAlot's avatar
ThxAlot
Super User
2 years ago
Cnt = 
ADDCOLUMNS(
    CROSSJOIN(
        DISTINCT( Sales[Date] ),
        DISTINCT( Salespersons[Salesperson] ),
        DISTINCT( Sales[Category] )
    ),
    "Cnt", CALCULATE( COUNTROWS( Sales ) ) + 0
)

  • kang990's avatar
    kang990
    Frequent Visitor
    2 years ago

    Hi ThxAlot , it worked in this way. Thank you for your help! 🙂

  • kang990's avatar
    kang990
    Frequent Visitor
    2 years ago

    A follow up question, how can I bring the Dept from Salespersons in to the summarized table?