cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
andre_kauber
Frequent Visitor

DAX summarize count of values filtering on a different column

I'm stuck on a simple one, also looked in the dax manual but I'm not able to find the solution. 

I want to obtain a count of, say, transactions by date, filtering on a different column. So, let's say I have the table 'cool', the columns [Date], [Transactions], and a third column with object sold [Object]. I want to create a new table, containing the dates and the count of transactions.

 

Table = SUMMARIZE('Cool','Cool'[Date],"Sales",COUNT('Cool'[Transactions]))

 

Now, how can I obtain the count of transactions per date for 'Cool'[Object]="Toy"?

 

Thanks

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft v-yulgu-msft
Microsoft

Re: DAX summarize count of values filtering on a different column

Hi @andre_kauber,

 

You could modify your formula as below:

Table =
SUMMARIZE (
    FILTER ( Cool, Cool[Object] = "Toy" ),
    Cool[Date],
    "Sales", COUNT ( Cool[Transactions] )
)

Regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Microsoft v-yulgu-msft
Microsoft

Re: DAX summarize count of values filtering on a different column

Hi @andre_kauber,

 

You could modify your formula as below:

Table =
SUMMARIZE (
    FILTER ( Cool, Cool[Object] = "Toy" ),
    Cool[Date],
    "Sales", COUNT ( Cool[Transactions] )
)

Regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
andre_kauber
Frequent Visitor

Re: DAX summarize count of values filtering on a different column

Thank you!

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors