After select a value (Chiclet slicer) i have 2 different values for the same formula

[Betigolo]

Hi,

Hi have a table with numbers 1 to 9.

Using power bi the user should select one value.

I need to get the value selected.

BUT:

First formula can get the value.

call the formula to be used again comes 0 value.

9 is the formula: 

Hours Predited = MIN(TBL_Hours[Power Hours])

I i call the "Hours Predited" cames: Blank Value

Already try using the formula and does not work.

Create an equal formula get blank also.

Do you honw what are happening here?

Many thanks for your help.

If 

[v-huizhn-msft · Accepted solution]

Hi @Betigolo,

When you click 9 in the Slicer, you want to get number 9 by creating a measure, right? If it is, please create the measure using the formula.

Hours Predited = SELECTEDVALUE(TBL_Hours[Power Hours])

OR

Hours Predited = CALCULATE(MIN(TBL_Hours[Power Hours]),ALLSELECTED(TBL_Hours))

Thanks,
Angelia

[Betigolo]

Hi, let me try your input. the value is not a direct selection, is a value from 2 imputs as bellow:  persons * hours per day

[Betigolo]

I have created 2 different tables as bellow and is working:

Prior: 1 table, with 3 colums (Persons; Hours; Persons * Hours), example:

1;1;1

1;2;2

2;1;2

2;2;4

3;1;3

3;2;6

And do not work.

After:

2 diferent tables:

1 table  = Persons

1 table = Hours

Result is now the SELLECTED persons * SELLECTED Hours.

Is working.