topic Creating masses of DAX-Measures in an efiicient way in DAX Commands and Tips

Creating masses of DAX-Measures in an efiicient way

thomasreick — Fri, 16 Sep 2022 13:16:22 GMT

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

Greg_Deckler — Fri, 16 Sep 2022 13:28:09 GMT

thomasreick MSHGQM lets you create your own parameterized measures:

thomasreick — Sat, 17 Sep 2022 10:20:16 GMT

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