Count of results in measure with DAX

[jperezfagor]

Hello!!

I have a table of users an access to an app like this:

Access	User	Date
True	A	01/06/2022
True	A	01/06/2022
True	B	01/06/2022
True	A	02/06/2022
True	B	02/06/2022
True	A	03/06/2022
True	C	03/06/2022
True	C	03/06/2022
True	D	03/06/2022

I would like to count how many users has accesed the app X times, the result here should be:

Num of users accesing X times	X
1	1
2	2
0	3
1	4

Desirably dinamically with DAX, since I want the results to change depending on slicers.

[amitchandak · Accepted solution]

@jperezfagor , I think you need the dynamic segmentation , the one I discussed here 

Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ

[jperezfagor]

That worked! You saved my life so you have gained a subscriptor, thanks!