Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello,
I need to calculate the amount of time each value appears in a particular column. The issue I'm having is that some rows have multiple values. Here's an example:
Column 1 |
A |
B |
A B D |
C D B |
E F |
I'd like to use a dax that will calculate each time the value appears. So the count would show A =2, B =3, D =2
Thank you!
Solved! Go to Solution.
Hi, @Cezenwoko
Enter a new table 'Table2' as below:
Then try measure as below:
Result = CALCULATE(COUNTROWS('Table1'),CONTAINSSTRING('Table1'[Column 1],MAX(Table2[Column1])))
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I am wanting to have a colunm that counts the rows.
This is my data but the ID does not count from 1, 2 ,3 and so on so thought I would add a colum to have the correct count per line, hope that makes sense
Hello @Cezenwoko
Try creating a calculated column using the following DAX formula:
you're a dawg for this one thanks for bailing me out. This should be the real accepted solution
thank you very much for the solution 🙂
Thank you for your response!
I initially tried this DAX but the results come out as: A = 1, B =1, ABD = 1. As opposed to counting each value individually.
Hi, @Cezenwoko
Enter a new table 'Table2' as below:
Then try measure as below:
Result = CALCULATE(COUNTROWS('Table1'),CONTAINSSTRING('Table1'[Column 1],MAX(Table2[Column1])))
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you!
I was looking for a way to create this without making another table but it seems like that's impossible right now
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
111 | |
109 | |
106 | |
90 | |
61 |
User | Count |
---|---|
165 | |
136 | |
134 | |
97 | |
86 |