- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How do I get count of "Yes" from this new created Dax column?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @bcbuckley13
There's 2 answers to this. There are actually 5 Yes in the Two Champions column
If you want that then create a mesure like this
Yes Count = CALCULATE(COUNTROWS('Badges'),FILTER('Badges', 'Badges'[Two Champions] = "Yes" ))
But if you want a distinct count of store ID's with a Yes then use this - the answer is 2
Yes Count = CALCULATE(DISTINCTCOUNT('Badges'[Store ID]),FILTER('Badges', 'Badges'[Two Champions] = "Yes" ))
Regards
Phil
Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.
Blog :: YouTube Channel :: Connect on Linkedin
Proud to be a Super User!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @bcbuckley13
There's 2 answers to this. There are actually 5 Yes in the Two Champions column
If you want that then create a mesure like this
Yes Count = CALCULATE(COUNTROWS('Badges'),FILTER('Badges', 'Badges'[Two Champions] = "Yes" ))
But if you want a distinct count of store ID's with a Yes then use this - the answer is 2
Yes Count = CALCULATE(DISTINCTCOUNT('Badges'[Store ID]),FILTER('Badges', 'Badges'[Two Champions] = "Yes" ))
Regards
Phil
Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.
Blog :: YouTube Channel :: Connect on Linkedin
Proud to be a Super User!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @bcbuckley13
Can you please provide some sample data.
regards
Phil
Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.
Blog :: YouTube Channel :: Connect on Linkedin
Proud to be a Super User!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @bcbuckley13,
You could directly put the column in a table field >choose "count" or "discount",and you will see the value you need:
Check the .pbix file attached if needed.
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
Subject | Author | Posted | |
---|---|---|---|
08-01-2023 08:17 AM | |||
09-25-2020 04:57 PM | |||
03-22-2024 10:22 AM | |||
04-02-2024 06:31 AM | |||
11-21-2023 08:06 AM |
User | Count |
---|---|
119 | |
74 | |
58 | |
56 | |
44 |
User | Count |
---|---|
183 | |
120 | |
80 | |
65 | |
57 |