Creating masses of DAX-Measures in an efiicient way

[thomasreick]

Hi there,

is there a more efficient way to create a lot of measure for comparing values then doing it one-by-one?

• I have to conditionally format values in a 11 x 4-Matrix visual.
• For that every Value needs to be compared to a definite Benchmark value (< 11 x 4, some benchmarks can be aggregated)
• To get the Benchmark measures I have created a pattern for a LOOKUPVALUE() measure to fetch values from the benchmark table
• General Rule:If (Matrixvalue > Benchmark;RED;"GREEN") or some other result to use in coloring-rule
• Actually there is a minimum number of Measures to create (only for comparison) of 2 x 11 x 4  = 88

My question: is there a way  / a tool to "import" prepared and parameterized measures to a PBI Model to avoid going one-by-one?

Any ideas?

thanky s for input

Thomas

[thomasreick]

Hi Greg,

thank you very much for your answer and the SDK provided in yur link.

Actually I am thinking about my approach to that task.

Situation:

• Matrix Visual is based on a normalised-2-table showing averages for consumed time-values for process steps (11 in columns) and productgroups (4 in rows).
• Each of the Steps has a benchmark judging the consumed time above/below benchmark-value
• 2 Process Steps are depending on what producgroup they belong to (only one more complication)
• Each combination Step/productgroup needs to be checked

AFAIK, I can only conditionally format the fore-/background colors based rules using ONE field/measure only.

Am I right?
So the using a matrix visual might not the right approach?

Do you know a way to solve this (besides using Card-Visuals per Step/PG-Combination...)

thx&brgds

Thomas

[Greg_Deckler]

@thomasreick MSHGQM lets you create your own parameterized measures:

gdeckler/MicrosoftHatesGregsQuickMeasures: Microsoft Hates Greg (github.com)

Microsoft Hates Greg - YouTube