show the no of login user while selecting range in slicer

[Shine_456]

Hi Friends,

I have a query.

I have a user table with login time and last logged in time.

for total login i used session=distinctcount( login time)

Now i need is in slicer I have 0,50,100,200,>200 to select. If i select 50 i need to get session>0 && session <=50 users

similarly for 100 i need to get session>50 && session <=100 users etc

for that I have taken new column as 

No_of_session = if(Table[session]>=0 && Table[session]<=50,50, if(Table[session]>=50 && Table[session]<=100,100, if(Table[session]>=100 && Table[session]<=200,200,300))). But I am not getting exact values.

from above images if I select 50, then <50 sessions should show.

Can any one tell me the logic to create new column

[v-yanjiang-msft]

Hi @Shine_456 ,

Is your problem solved? If so, would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirment will find the solution quickly and benefit here, thank you!

Best Regards,
Community Support Team _ kalyj

[v-yanjiang-msft · Accepted solution]

Hi @Shine_456 ,

I used the formula you provided, and it can successfully get the correct result.

If you want to have all the ranges in the slicer, you can create a new table. Create relationship between the two tables.

It also works fine.

I also create another table with user name to verify it, still works fine, you can download the attached file to see the details.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.