Create a Dynamic Measure

[Anonymous]

Hi, 

I want to create a dynamic measure. I have various colunm with values, whose name is Jar, for example, Color Jar, Smell Jar, Aftertaste Jar, Fizziness Jar etc. 

I created this measure: 

Measure Color = 
                VAR color = 
                           DIVIDE(COUNTA('consumer'[Color JAR]),
                            CALCULATE(COUNTA('consumer'[Color JAR]),
                            ALLEXCEPT(consumer, consumer[preference])),
                            0
                            )
                RETURN
                        color

 And i've this table with these fields:

and I wanted to add everything in the same table, that is, at the moment for each Jar I have a table, a table for the Jar color, another for the Jar smell, but I wanted to create a dynamic metric that aggregates all the metrics of type:

GENERIC MEASURE = VAR color = 
                            DIVIDE(COUNTA('consumer'[Color JAR]),
                            CALCULATE('consumer'[count color jar],
                            ALLEXCEPT(consumer, consumer[preference])),
                            0
                            )
                            VAR smell = 
                            DIVIDE(COUNTA('consumer'[Smell JAR]),
                            CALCULATE('consumer'[count smell jar],
                            ALLEXCEPT(consumer, consumer[preference])),
                            0
                            )
                            VAR taste =
                            DIVIDE(COUNTA('consumer'[Taste strength JAR]),
                            CALCULATE(COUNTA(consumer[Color JAR]),
                            ALLEXCEPT(consumer, consumer[preference])),
                            0
                            )
                            VAR fizziness = 
                            DIVIDE(COUNTA('consumer'[Fizziness JAR]),
                            CALCULATE(COUNTA(consumer[Fizziness JAR]),
                            ALLEXCEPT(consumer, consumer[preference])),
                            0
                            )
                            VAR bitterness = 
                            DIVIDE(COUNTA(consumer[Bitterness JAR]),
                            CALCULATE(COUNTA(consumer[Bitterness JAR]),
                            ALLEXCEPT(consumer, consumer[preference])),
                            0
                            )
                            VAR alcohol = 
                            DIVIDE(COUNTA(consumer[Alcoholc Leval JAR]),
                            CALCULATE(COUNTA(consumer[Alcoholc Leval JAR]),
                            ALLEXCEPT(consumer, consumer[preference])),
                            0
                            )
                            VAR aftertaste =
                            DIVIDE(COUNTA(consumer[Aftertaste Liking]),
                            CALCULATE(COUNTA(consumer[Aftertaste Liking]),
                            ALLEXCEPT(consumer, consumer[preference])),
                            0
                            )
                            VAR refreshing =
                            DIVIDE(COUNTA(consumer[Refreshing]),
                            CALCULATE(COUNTA(consumer[Refreshing]),
                            ALLEXCEPT(consumer, consumer[preference])),
                            0
                            )
                            VAR easy =
                            DIVIDE(COUNTA(consumer[Refreshing]),
                            CALCULATE(COUNTA(consumer[Easy to drink]),
                            ALLEXCEPT(consumer, consumer[preference])),
                            0
                            )

It's possible? 

Kind regards.

[v-frfei-msft]

Hi @Anonymous,

Could you please share your sample data and excepted result to me, if you don't have confidential data? Please upload your file to One Drive and share the link here.

Regards,

Frank