Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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
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
Hello! What I have to do if I need filter by two or more criterias?
Thank you!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
97 | |
75 | |
65 | |
53 |
User | Count |
---|---|
144 | |
103 | |
98 | |
85 | |
64 |