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! 🙂