topic Re: search data with selectdvalue function in DAX Commands and Tips

search data with selectdvalue function

Joshua_ — Tue, 24 Mar 2020 23:08:44 GMT

Can I get kpi based on a column that is not a primary key?

for example
I selected 31-01-2019 and department 1, result is 80.0%

I want to show the kpi of the region through the ID_departamet.

I tried this, but do you add the KPIs (156.0%)

CALCULATE(
SUM(KPI[PORCENT]),
FILTER(
ALL(KPI),
KPI[LOCATION]=SELECTEDVALUE(LOCATION[REGION])
)

thank you....

Re: search data with selectdvalue function

Greg_Deckler — Wed, 25 Mar 2020 00:38:28 GMT

Perhaps:

Measure = VAR __deptID = SELECTEDVALUE('LOCATION'[ID_DEPARTMENT]) VAR __locID = LOOKUPVALUE('LOCATION'[ID_REGION],[ID_DEPARTMENT],__deptID) VAR __date = SELECTEDVALUE('CALENDAR'[DATE]) RETURN LOOKUPVALUE('KPI'[PORCENT],[ID_LOCATION],__locID,[DATE],__date)

Re: search data with selectdvalue function

Joshua_ — Thu, 26 Mar 2020 17:59:29 GMT

Thank you very much my friend.