Is it possible to let users to select columns to be used in the measure?

[brickanalyst]

Hey, 

I woke up to this crazy idea this morning. So, imagine we have a very easy calculation. Let's say we have 2 slicers and we select A from the first slicer, and B from the second slicer. And our measure simply will summarize these two; 

measure = [Selected Column in the first slicer] + [Selected Column in the second slicer]

Please let me know if this is possible, it doesn't matter you have an answer I want to try it. 

Any ideas?

[Anonymous]

Hi @brickanalyst ,

Yes, as you said. Dynamically selecting specific column names based on the slicer is not possible. The solution is dynamic measurement.

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[brickanalyst · Accepted solution]

I did similar what you guys mentioned. Let's say 5 different measures and depending on your selection you can bring how many measures you can and compare between each other. I wanted to do that way yes but I'm talking about 100 measures here. Yes we can create 100 measures and throw them into the slicer that's a solution.

What I was thinking not the measure is created and pickem them up via selecting them in the slicer, but selected column names that will be used in the measure (same calculation) and that will bring the result after you selected.

I guess that's not possible, if you guys agree then we can close this ticket: solution is dynamic measure.
Please let me know, thanks !
@Greg_Deckler 
@Ritaf1983 

[Ritaf1983]

Hi @brickanalyst 
I doubt there is something better than What-if parameters for this goal...

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[Ritaf1983]

Hi @brickanalyst 
It sounds something like a dynamic measure/field parameter/parametrs .
Take a look at these videos:

https://www.youtube.com/watch?v=28PDdA3SROU&t=5s
https://www.youtube.com/watch?v=ODNsd1G4tDM&t=199s

https://www.youtube.com/watch?v=TLiqqIsk1CU&t=579s

For more specific suggestion 

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[Greg_Deckler]

@brickanalyst If it is possible, and that's a big if, then I would think it would have to involve Field Parameters.