Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Use parameter value for calculation using selected value

Hi, Using the code below I get a result based on a calculation with the number 120000000. In stead of that I tried using SELECTEDVALUE but no result. Any help would be appreciated. Cheers, Herma...
Need Help
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Hugh!

Thanks for your reply. I was thinking the same so I created a series of parameters like: 

Budget = GENERATESERIES(110000000, 130000000, 500000) and putting these in a slicer. I expected that using SELECTEDVALUE on this would work, but it doesn't. I tried INT as well to change it to a number, but to no avail.
Any other thoughts?
Cheers,
Herman
HughLa's avatar
HughLa
Resolver IV
3 years ago

Hi Herman

 

When put the measure in a card visual does it show you selected value?

 

Like this:

 

Can you maybe also share your selected value measure?

 

Regards

Hugh

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Hugh,

    The selected value shows up in a card, see screenhot.

    DAX code is: 

    Geselecteerd = INT(SELECTEDVALUE(Budget[Budget]))

    The numbers you see are based on the hardcoded number 120000000.

    On invoking this like in your example, nothing is showing up in the grid.

    Cheers,

    Herman