Forum Discussion

zazaalaza's avatar
zazaalaza
Frequent Visitor
2 years ago
Solved

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'[Valu...
DAX
matrix
Matrix Visual
  • AlexisOlson's avatar
    AlexisOlson
    2 years ago

    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
    )

     

AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
2 years ago

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
    )

 

  • zazaalaza's avatar
    zazaalaza
    Frequent Visitor
    2 years ago

    The totals are reversed, Should also be negative and positive 🙂 But cool, this already works

    • AlexisOlson's avatar
      AlexisOlson
      Icon for Super User rankSuper User
      2 years ago

      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.