Forum Discussion

grggmrtn's avatar
grggmrtn
Icon for Post Patron rankPost Patron
6 years ago
Solved

DAX - if/then giving error about integer values, when there are none?

I'm working in three tables: The fact table, and two dimensions.   In the fact table I need to make a calculated column based on values (text) from columns in the two dimensions. Shouldn't be a pro...
Need Help
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hello @grggmrtn

    Try this.

    Frekvens Filter = 
VAR __isWeek = RELATED( 'nexus2 Dim_Frekvens'[Hver x] ) = "WEEK"
VAR __isIn = RELATED( 'nexus2 Dim_Indsats'[Indsats navn] ) IN { "R1 - Rengøring*",  "VP - Tøjvask*" }
RETURN 
IF (
    __isWeek && __isIn;
    "OK";
    "NOT OK"
)

    Best regards
    Mariusz

    If this post helps,then please consider accepting it as the solution.

    Please feel free to connect with me.
    Linkedin

grggmrtn's avatar
grggmrtn
Icon for Post Patron rankPost Patron
6 years ago

Hi V-lianl-msft 

 

The data type of all fields has been checked.

 

Dummy data shouldn't be necessary. There are three simple tables - 1 fact table with only key columns for each dimension, and two dimensions that have their respective key columns (values in them are integers, but I'm not using they keys in my code), and another column with the text values that I'm trying to compare.

 

Yes, I could use FORMAT, I'm just trying to figure out what integers Power BI thinks I'm using here?

 

grggmrtn's avatar
grggmrtn
Icon for Post Patron rankPost Patron
6 years ago

My bad - I overlooked something. Mariusz gave a good answer 🙂