User Profile
Chris_23
Helper II
Joined 6 years ago
User Widgets
Contributions
RANKX Measure should ignoring Higher-Level Context for Independent Ranking
Hello everyone, I have an issue with a RANKX measure. I want to create a ranking on the second level based on a measure, and this works well (1) for only two Levels: [Name] and [Supervisor]: Rank1 = CALCULATE( RANKX( Filter(ALLSELECTED(Master[Name]), Not(ISBLANK([Sum]))), [Sum], , ASC ), REMOVEFILTERS(Master[Supervisor]) ) However, when I add a higher level (Region), the ranking on the second (Name) level is created within the context of the first level (2) even with Removefilters on Region: CALCULATE( RANKX( Filter(ALLSELECTED(Master[Name]), Not(ISBLANK([Sum]))), [Sum], , ASC ), REMOVEFILTERS(Master[Supervisor]), REMOVEFILTERS(Master[Region]) ) What I want instead is for this column to ignore the highest level and have the ranking remain independent of the Region. RankX_3Level.pbix Thank you very much for your help! ChrisDistinctcount across 3 levels without countning X and blanks() in the measure
Hello guys, I have a matrix with 3 levels. For the second level, a sum is calculated over the third and second levels if the second Level is "open". Otherwise, there is an 'X'. Now, I want to know for each row how many values from the second level are used to calculate sums, within the respective filter context. In the corresponding example, the value '5' should be assigned for each entry Distinctcount w.o. X.pbix Any idea how I can get this done? Thank you for your help! ChrisDistincount in a Matrix with different Levels
Hello community, I have a matrix with 3 levels. When the second level is open, a sum is calculated over the third and second levels. Otherwise, there is an 'X'. Now, I want to know for each row how many values from the second level are used to calculate sums, within the respective filter context. In the corresponding example, the value '7' should be assigned for each entry Distinctcount.pbix What do I need to adjust so that the measure delivers the desired result? Thank you ChrisMeasure, which takes into account two levels in the point diagram
Hello, I need help with a measure for a scatter plot that incorporates two levels. OBIX: https://1drv.ms/u/c/f72340abfdddccc2/EYccUd7tuBZHvAk-XPmsZ-oBXj6SC1bYNhD5Dcbz1LpjBg?e=5hc5lf On the X-axis, the context should be on the lower level. On the Y-axis, I want to calculate the deviation from the group (first level calculation). Since I want to display the sales on the lower level, I need them in the values area of the scatter plot. The goal is that if I remove the values from the X-axis, only two points should appear in the chart. One with 50 overlapping Electronics = 32755 and one with 50 overlapping Clothing = 30031. Kind regards Chris
