Forum Discussion
gilr1975
Helper I
6 years agoNeed help to present data for specific ranges
Hello, I have the following information: Employee Id, Salary, salary rank: Emp.Id Salary Salary rank 100 1000 50% 101 1200 74% 102 1300 80% 103 1350 82% 104 1500 ...
v-xuding-msft
Community Support
6 years agoHi 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]
)
)
)
)
Reference:
https://www.daxpatterns.com/dynamic-segmentation/
You could download my sample to have a try.
gilr1975
Helper I
6 years agoThank you very much.
- v-xuding-msft6 years ago
Community Support
You're welcome. I'm glad it works for you.😊