Forum Discussion

RemiAnthonise's avatar
RemiAnthonise
Helper V
8 years ago
Solved

DAX: Selectedvalue in IF doesn't work

Hi guys,   I have the following measure:   Werkuren per maand = IF ( SELECTEDVALUE ( Workers[Name] ) = "Test Persoon"; CALCULATE ( SUM ( 'Calendar'[Werkdagen 4 dagen] ) ) * [Werkuren 9]; CALC...
Need Help
Show and Tell
Tips and Tricks
  • tex628's avatar
    tex628
    8 years ago

    Alright then! 

     

    Then i have some things that I would like you to check:

     

    * Do a new measure, Measure = SELECTEDVALUE(Workers[Name])

    * Place this measure next to the name column and compare the values. If they are not the same something is off. 

    * Also check the format of the name column. 

     

    I tried to recreate your problem but mine seems to work...

     

    hours/month = IF(SELECTEDVALUE(Table1[Person])="TestP";
    SUMX(Table1;Table1[9workinghours]*Table1[9hrmonthdays]);
    SUMX(Table1;Table1[8workinghours]*Table1[8hrmonthdays])
    )

tex628's avatar
tex628
Community Champion
8 years ago

Alright then! 

 

Then i have some things that I would like you to check:

 

* Do a new measure, Measure = SELECTEDVALUE(Workers[Name])

* Place this measure next to the name column and compare the values. If they are not the same something is off. 

* Also check the format of the name column. 

 

I tried to recreate your problem but mine seems to work...

 

hours/month = IF(SELECTEDVALUE(Table1[Person])="TestP";
    SUMX(Table1;Table1[9workinghours]*Table1[9hrmonthdays]);
    SUMX(Table1;Table1[8workinghours]*Table1[8hrmonthdays])
    )

Kolumam's avatar
Kolumam
Post Prodigy
7 years ago

Brilliant answer tex628 It worked for me as well.