Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
I want to count number of English messages and hinglish messages for example hinglish like Mai accha hu, AAP kaha se hai etc
@Ashanaik
Let's take an example suppose you have column in which you have different english and hinglish messages, To count them by english, hinglish category you have to add a column like "Flag" for english meassages = 1 and for hinglish meassages = 0.
Then you can write dax(Make measure):
Flag is column to differentiate type of messages.
For english messages
CALCULATE( COUNT(Messages), Flag = 1)
For Hinglish messages
CALCULATE( COUNT(Messages), Flag = 0)
If i have given the answer. Please mark as a solution.
Thanks
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 9 | |
| 5 | |
| 4 | |
| 3 | |
| 3 |
| User | Count |
|---|---|
| 23 | |
| 12 | |
| 11 | |
| 10 | |
| 9 |