Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
gilr1975
Helper I
Helper I

Need help to present data for specific ranges

Hello,

 

I have the following information: Employee Id, Salary, salary rank:

 

Emp.IdSalarySalary rank
100100050%
101120074%
102130080%
103135082%
104150091%

 

I would like to present employees information for several ranges of salary ranks:

0-50%

510-75%

75-85%

85% and more

 

1. To present on visualization chart:

Axis x - ranges of salary ranks

Axis y - number of emplyees

 

2. Each time I press on shart (e.g. on range 75-85%), I will see data in visualization table for only these employess.

In case of 75-85% I will get data only for 2 employess:

Emp.IdSalarySalary rank
102130080%
103135082%

 

I created a range table with MIN and MAX + some measures.

The main one is:

Count Rating =

IF(NOT(ISBLANK('Rating'[Rating_Salary])),

CALCULATE(

COUNT('compare to survey'[EmpId),

 FILTER('compare to survey', 'compare to survey'[rate]

< 'Rating'[MaxThreshold_rating]), FILTER('compare to survey', 'compare to survey'[rate] >= 'Rating'[MaxThreshold_rating])))

 

However, I receive information for all employess as following:

Emp.IdSalaryCount Rating
1001000 
1011200 
10213001
10313501
1041500 

 

How can I fix it?

5 REPLIES 5
v-xuding-msft
Community Support
Community Support

Hi @gilr1975 ,

 

I create a sample. Please check if it is what you want.

Measure =
CALCULATE (
    COUNT ( 'Table'[Emp.Id] ),
    FILTER (
        VALUES ( 'Table'[Salary rank] ),
        COUNTROWS (
            FILTER (
                Rating,
                'Table'[Salary rank] >= Rating[MinThreshold_rating]
                    && 'Table'[Salary rank] <= Rating[MaxThreshold_rating]
            )
        )
    )
)

1.PNG

Reference:

https://www.daxpatterns.com/dynamic-segmentation/ 

 

You could download my sample to have a try.

 

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

Thank you very much.

 

You're welcome. I'm glad it works for you.😊

 

Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
amitchandak
Super User
Super User

Thanks a lot!

It helped me. It is exactly what I looked for.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.