Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |