Forum Discussion

cosminc's avatar
cosminc
Icon for Post Partisan rankPost Partisan
7 years ago
Solved

Measure with if with filtered value

Hi, I try to create a measure based on a filter value and an if something like this: if(source(salesmen) slicer="George",4, if(source(salesmen) slicer ="Mary",0)) can you help me please with the ...
Need Help
  • Stachu's avatar
    Stachu
    7 years ago

    you need SELECTEDVALUE, I'd also consider wheter you want to use BLANK - calculation wise it acts as 0, display wise it acts as null

    IF(
    SELECTEDVALUE(Source[Salesman]) = "George",
    4,
    IF(
        SELECTEDVALUE(Source[Salesman]) = "Mary",
        0,
        BLANK()
    )
)
Stachu's avatar
Stachu
Icon for Community Champion rankCommunity Champion
7 years ago

you need SELECTEDVALUE, I'd also consider wheter you want to use BLANK - calculation wise it acts as 0, display wise it acts as null

IF(
    SELECTEDVALUE(Source[Salesman]) = "George",
    4,
    IF(
        SELECTEDVALUE(Source[Salesman]) = "Mary",
        0,
        BLANK()
    )
)
fredzegers's avatar
fredzegers
New Member
4 years ago

Hi guys,

 

I do have a similar issue. This quick measure does not work. Does anyone have an idea?

 

Diff in % van Revenue Gross =
VAR __BASELINE_VALUE =
    CALCULATE(
        SUM('DWH'[Revenue Gross]),
            'DWH'[Delivery Date.Datum].[Jaar] IN {
IF(
SELECTEDVALUE(DWH[Delivery Date.Jaar]) = 2022,2021,
IF(
SELECTEDVALUE(DWH[Delivery Date.Jaar]) = 2021,2020,
IF(
SELECTEDVALUE(DWH[Delivery Date.Jaar]) = 2020,2019,
BLANK()
)
))}
    )
VAR __MEASURE_VALUE = SUM('DWH'[Revenue Gross])
RETURN
    IF(
        NOT ISBLANK(__MEASURE_VALUE),
        DIVIDE(__MEASURE_VALUE - __BASELINE_VALUE, __BASELINE_VALUE)
    )