cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jperezfagor
Frequent Visitor

Count of results in measure with DAX

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.

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

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

 

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

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

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

 

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

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

Helpful resources

Announcements
Join Arun Ulag at MPPC23

Join Arun Ulag at MPPC23

Get a sneak peek into this year's Power Platform Conference Keynote.

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors
Top Kudoed Authors