Forum Discussion
POWER BI DAX Classification on Measure and Measures as Visual Legend
Hi Experts, I'm trying to build below kind of visual as an output, but visual legend setting is not taking measure. Basically, I was created a conditional measure based on below conditio...
Hi Team,
We were able to solve this by using disconnected table like below.and created the following Measure
Session Count (w Range) = VAR _MinRange = MIN( 'Range Table'[MIN] ) VAR _MaxRange = MAX( 'Range Table'[MAX] ) RETURN IF( [SessionCount] >= _MinRange && [SessionCount] <= _MaxRange, [SessionCount], BLANK() )
and I added Range (from the new table) to your table visual
For chart, I created this measure (note that it relies on the measure above)
Unique Count = COUNTX( VALUES( data[USERRANK] ), [Session Count (w Range)] )
and I added the Range column as the chart legend
Regards,
Anonymous
Hi Team,
We were able to solve this by using disconnected table like below.
and created the following Measure
Session Count (w Range) = VAR _MinRange = MIN( 'Range Table'[MIN] ) VAR _MaxRange = MAX( 'Range Table'[MAX] ) RETURN IF( [SessionCount] >= _MinRange && [SessionCount] <= _MaxRange, [SessionCount], BLANK() )
and I added Range (from the new table) to your table visual
For chart, I created this measure (note that it relies on the measure above)
Unique Count = COUNTX( VALUES( data[USERRANK] ), [Session Count (w Range)] )
and I added the Range column as the chart legend
Regards,
Anonymous