DAX For counting strings - Help with DAX

[Medo]

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:)

[SpartaBI · Accepted solution]

@Medo you mean like this?

Attached the file: DAX For counting strings - Help with DAX.pbix

      

Showcase Report – Contoso By SpartaBI

[Medo]

@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

[SpartaBI]

@Medo 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.

[Medo]

Thanks a lot @SpartaBI 😊

[SpartaBI]

@Medo my pleasure 🙂
Hey, check out my showcase report - got some high level stuff there. Sure you will find there a lot of cool ideas. 
https://community.powerbi.com/t5/Data-Stories-Gallery/SpartaBI-Feat-Contoso-100K/td-p/2449543
Give it a thumbs up over there if you liked it 🙂