Forum Discussion
DAX For counting strings - Help with DAX
Hi Folks, I need small help with this one please 😞
IF I have below table:
| POP time | Items | Frequency |
| 4 | item1 | |
| 7 | item2 | |
| 21 | item3 | |
| 16 | item4 | |
| 8 | item5 | |
| 11 | item6 | |
| 10 | item7 | |
| 5 | item8 | |
| 7 | item9 | |
| 17 | item10 | |
| 5 | item11 | |
| 2 | item12 | |
| 5 | item13 | |
| 6 | item14 | |
| 3 | item15 | |
| 20 | item16 | |
| 5 | item17 | |
| 6 | item18 | |
| 12 | item19 | |
| 5 | item20 | |
| 7 | item21 | |
| 10 | item22 | |
| 3 | item23 | |
| 2 | item24 | |
| TOTAL # |
I want to find the count of items per POP Time
for example in POP TIME 5 there are 5 count of items
| 5 | item8 |
| 5 | item11 |
| 5 | item13 |
| 5 | item17 |
| 5 | item20 |
and in POP Time 10 there is 2 Items
| 10 | item7 |
| 10 | item22 |
After that I'll get :
| POP time | Count Of Items |
| 5 | 5 |
| 10 | 2 |
| 3 | and so on |
| 11 | |
| … |
The finel equation is frequency = Count of Items per POP TIME divided by ( / ) Total# (Total count of Items for each POP Time.
I need to find if there is a way in DAX to create such calculation.
Hope it's clear and thanks to all suggestions:)
5 Replies
SpartaBI Thanks for the quick response, I think yes that's exactly what I'm looking for in the frequency, if the item count is counting the strings count per POP time
Anonymous hey, cool. I shared a link to download the file in my previous response 🙂
Please don't forget to accept that reponse as a solution.