Using Parameter for calculation

[Anonymous]

Hi all, 

I'm using Parameter not for slicing data but for calculation.

So a measure which refers to the value of a parameter creates my result. 

If I change the value of the parameter the measure changes itsresult.

Now I'm having issues with the visualisation of that measure result. 

I can't use the measure for maps for example. 

I only see an alternative to work with calculated columns and changing the values via variable in there but that's not really user friendly. Not sure if that would work though ...

What could you recommend me? 

Many Thanks

lanko

[parry2k]

@Anonymous what is this measure? Where you want to use it on the map? Why you cannot use it on the map? Provide a bit more context, example, screenshots and what you are trying to achieve.

Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[Anonymous]

Hi @parry2k,

I created that report with the measure Result: 

Need to cover data for data protection reasons ... 

Now I want to have an report showing 

Customer	Result	Quantity Result
1100***	A	13
1100***	B	0
1100***	C	0
1100***	D	11
...	...	...

In order to visualise that result I would like to create a map:

Showing Customer (related Cities are available)

- bubble colours: Result (e.g A = red, B = Blue, ...) 

Power BI requests doesn't acceps measures "data fields" in maps.

So do I need to do my formula in a calculated column instead of a measure?

If yes I'm loosing the ability to change the results by changing paramaters values. (As I mentioned the result is depending on pararmeters)

That's because you can't work with parameters in calculated columns. 

I hope that makes sense.

Christoph