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.
I created a table account
what i want to to is to create a measure in order to put in Column value of the graph,
and should be like this
if I select 11999 then put in column value [11999] [11999 budget] [ 11999 prevyear]
if I select 58229 then put in column value [58229 ] [58229 budget] [ 58229 prevyear]
if I select 15999 then put in column value [15999 ] [15999 budget] [ 15999 prevyear]
if I select 89999 then put in column value [89999 ] [89999 budget] [ 89999 prevyear]
for every selection must appear 3 column
those are measure already made [11999] [11999 budget] [ 11999 prevyear]
I try use SELECTEDVALUE but I can't make it work
Solved! Go to Solution.
Make sure you have measures for all of your values,
then make 3 measures:
Measure1:
Amount = IF(SELECTEDVALUE([Account])="11999" ; [11999] ; IF(SELECTEDVALUE([Account])="15999" ; [15999] ; IF(SELECTEDVALUE([Account])="58229" ; [58229] ; IF(SELECTEDVALUE([Account])="89999" ; [89999] ; BLANK() ))))
Measure2:
Budget = IF(SELECTEDVALUE([Account])="11999" ; [11999Budget] ; IF(SELECTEDVALUE([Account])="15999" ; [15999Budget] ; IF(SELECTEDVALUE([Account])="58229" ; [58229Budget] ; IF(SELECTEDVALUE([Account])="89999" ; [89999Budget] ; BLANK() ))))
Measure3:
Budget = IF(SELECTEDVALUE([Account])="11999" ; [11999prevyear] ; IF(SELECTEDVALUE([Account])="15999" ; [15999prevyear] ; IF(SELECTEDVALUE([Account])="58229" ; [58229prevyear] ; IF(SELECTEDVALUE([Account])="89999" ; [89999prevyear] ; BLANK() ))))
User | Count |
---|---|
77 | |
75 | |
61 | |
60 | |
46 |
User | Count |
---|---|
109 | |
95 | |
86 | |
79 | |
61 |