Lookupvalue with multiple conditions in one column

[Anonymous]

Hi there, 

basically I am trying to get this overall total of open revenues as shown in this matrix: 

The matrix is filtered by the tooling settlement deadline and the order status. 

As you can see, both (need to) have multiple conditions selected.

I am trying to find a measure which dynamically calculates the overall total to show it in a card visual.

Max FC FY Tooling = 
LOOKUPVALUE(Bericht[Offene Erlöse], Bericht[Auftragsstatus], SELECTEDVALUE(Bericht[Auftragsstatus]))

I tried using LOOKUPVALUE and CALCULATE in combination with FILTERS, but each time I ended up getting '(Blank)' because there are multiple conditions selected in the slicers.

Is there a way to get the overall total as displayed in the table using multiple selections in the slicers?!

[nandic · Accepted solution]

Hi @Anonymous ,

I am not sure if i understand the question, i will need more info.

You currently have total value in crosstab, and you would like to display that same value in card?
If this is the case, what happens when you add card object and drag measure from matrix in this card object? It should display same value as total on matrix.

Another thing, if you are using calculation for selected items and there is multiple selection available, you should use AllSelected instead of SelectedValue.

Cheers,

Nemanja