Forum Discussion
Unsolvable DAX conundrum in Matrix Visual?
Hi,
I have a matrix visual that is made from 2 unrelated tables and measures that executes against those 2 tables.
Test Measures:
Positive =
IF (
SELECTEDVALUE ( 'Columns'[Value] ) = SELECTEDVALUE ( 'Rows'[Value] ),
BLANK(),
RANDBETWEEN ( 10, 100 )
)Negative =
IF (
SELECTEDVALUE ( 'Columns'[Value] ) = SELECTEDVALUE ( 'Rows'[Value] ),
BLANK(),
RANDBETWEEN ( 10, 100 ) * - 1
)
What I would like to do is to merge the 2 measures such that the positive values display above the diagonal line and the negative values are displayed below the negative values.
I am having problems even approaching the issue, here is the powerbi file for reference: https://file.io/ZPVaVYkPmMrz
Would really appreciate if someone could point me in the right direction.
Try this:
VAR _Row = SELECTEDVALUE ( 'Rows'[Value] ) VAR _Col = SELECTEDVALUE ( 'Columns'[Value] ) RETURN SWITCH ( TRUE (), _Row < _Col, RANDBETWEEN ( 10, 100 ), _Row > _Col, RANDBETWEEN ( 10, 100 ) * -1 )
3 Replies
Try this:
VAR _Row = SELECTEDVALUE ( 'Rows'[Value] ) VAR _Col = SELECTEDVALUE ( 'Columns'[Value] ) RETURN SWITCH ( TRUE (), _Row < _Col, RANDBETWEEN ( 10, 100 ), _Row > _Col, RANDBETWEEN ( 10, 100 ) * -1 )The totals are reversed, Should also be negative and positive 🙂 But cool, this already works
That's because the row/column value is blank for those, which is treated like a zero when compared to 1-10.
I don't know what totals actually make sense in your scenario, so I didn't attempt to adjust them.
