Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
64 |