A measure with 3 conditionals diferent

[Anonymous]

Hi i´m new here i learn a lot in this forum,i have a question that i could found anywhere so here is
i have 2 measures A an B both are COUNTS of id and B the same but have a filter so
MeasureA > Measure B 

then i have a rowC wich have 3 diferent values (1,2 and 3)

so my question is there is a way that i could make the following next measure?

MeasureNew
if value rowC is 1 then measureA-MeasureB

if value rowC is 2 then measureA

if value rowC is 3 then measureA+MeasureB

is for a visual that have to show nor a matrix.

[Anonymous · Accepted solution]

Hi, 

try this

Measure = IF(

SELECTEDVALUE(RowC) = 1,

[MeasureA] - [MeasureB],

IF(

SELECTEDVALUE(RowC) = 2,

[MeasureA],

IF(

SELECTEDVALUE(RowC) = 3,

[MeasureA] + [MeasureB]

)

)

)

[rocky09]

try this

Measure = SWITCH(TRUE(),
                    [RowC] = 1, [MeasureA] - [MeasureB],
                    [RowC] = 2, [MeasureA],
                    [RowC] = 3 , [MeasureA] + [MeasureB])

[Anonymous]

Hi rocky this solutuon don"t work... I think because the swich formula doesn't let me put rowC because is not a measure is a row of a table.

[v-frfei-msft]

Hi @Anonymous ,

Could you please share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

[Anonymous]

I @v-frfei-msft have a issue about confidenciality so i gonna try to put images to make a better explanation (all is in a same table):

First image a measure that counts id but with a filter of a row called MATRIZ RC wich have 3 values yellow black and gray, the second image show a measure that also is a count with the same filter but with another filter wich is a column "yes or no" so what i need is create a new measure that follows in a visual:

NEWMEASURE:
Yellow1-Yellow2
black1
gray1 + gray2

so in my visual should be for "ENERO" (JANUARY) yellow =500 black= 61  and gray =150

i hope i get myself clear thanks for the attention.