Forum Discussion
Is measure context a thing?
Hi Mahesh,
Unfortunately I can't share a file but to give more context...
Card 1 displays the results of Measure 1, results of Measure 1 = abc
Card 2 displays the results of Measure 2, results of Measure 2 = xyz
Card 3 displays the results of Measure 3, results of Measure 3 = mno
i want to conditionally format the background of these cards based on the results of the measures.
I could create three measure to do this:
Card 1 formatting: IF(CONTAINSSTRING([Measure1], "abc"), "#DS351C", "#00703C")
Card 2 formatting: IF(CONTAINSSTRING([Measure2], "abc"), "#DS351C", "#00703C")
Card 3 formatting: IF(CONTAINSSTRING([Measure3], "abc"), "#DS351C", "#00703C")
Or i could do a switch statement as per themistoklis but is there a function that sees the measure context of the visual that would allow me to have a single measure that i don't have to populate with all measures?
hello Anonymous ,
can i know all measure calculated by one column or different column use by every measure and can share your measure writtend.