How to index values in a table in PowerBI?

Question

Just have a very simple question on how to index a value in PowerBI, suppose I have the following data set loaded.

Now, suppose I want the value 55 from the alert status column. Index wise (starting from 0), it would be (4, 2). What is the easiest way to select value 55? For example, in Python, I can go Table[4, 2].

This might help you: stackoverflow.com/questions/50113354/… — Strawberryshrub
– Strawberryshrub, Commented Jan 15, 2020 at 5:18

Kosuke Sakai · Accepted Answer · 2020-01-15 05:53:59Z

1

Here is a DAX expression that returns the scalar value 55.

CALCULATE (
    SELECTEDVALUE ( 'Table'[Alert Status] ),
    'Table'[Status] = 4
)

You can quickly examine this by clicking New Table in the Modeling tab, and copy & pasting the following formula.

Test = ADDCOLUMNS (
    ROW ( "Status to Lookup", 4 ),
    "Result",
    VAR StatusToLookup = [Status to Lookup]
    RETURN CALCULATE (
        SELECTEDVALUE ( 'Table'[Alert Status] ),
        'Table'[Status] = StatusToLookup
    )
)

answered Jan 15, 2020 at 5:53

Kosuke Sakai

2,4112 gold badges8 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to index values in a table in PowerBI?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related