Forum Discussion

patkang's avatar
patkang
Helper I
5 years ago
Solved

Conditional output based on other DAX

Dear Community   I am trying to create a text output if a countrow function produces a certain output.  Consider the table below. It shows a list of positions that potential nominees will take ove...
Need Help
Show and Tell
Tips and Tricks
  • FrankAT's avatar
    FrankAT
    5 years ago

    patkang ,

    with your sample data I get the following solution:

     

     

    Nominees = 
VAR CountHighIntelligence = CALCULATE(COUNTROWS('Table'), 'Table'[Intelligence Id] = "High")
RETURN
    IF(CountHighIntelligence < 2 , 
    "risky" , 
        IF(CountHighIntelligence >= 4 ,
         "Strong nominess" , "not risky"
        )
    )

    With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
    FrankAT (Proud to be a Datanaut)

FrankAT's avatar
FrankAT
Community Champion
5 years ago

patkang ,

with your sample data I get the following solution:

 

 

Nominees = 
VAR CountHighIntelligence = CALCULATE(COUNTROWS('Table'), 'Table'[Intelligence Id] = "High")
RETURN
    IF(CountHighIntelligence < 2 , 
    "risky" , 
        IF(CountHighIntelligence >= 4 ,
         "Strong nominess" , "not risky"
        )
    )

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)

  • patkang's avatar
    patkang
    Helper I
    5 years ago

    FrankAT 
    Thanks a lot, They don't call him super user for no reason 🙂

     

    On top of that, if I want to count the number of strong, risky or not risky positions. What measure could I apply for this? In that case it would be 3 times 1. But if i would have more than 3 positions and would want to aggregate the number of those positions, what would be the best way to do it?

    • FrankAT's avatar
      FrankAT
      Community Champion
      5 years ago

      Hi patkang ,

      in this case you should use the SWITCH() function, example

       

      Nominees with SWITCH = 
VAR CountHighIntelligence = CALCULATE(COUNTROWS('Table'), 'Table'[Intelligence Id] = "High")
RETURN
    SWITCH(TRUE(),
        CountHighIntelligence = 1 , "try again",
        CountHighIntelligence = 2 , "nice try",
        CountHighIntelligence = 3 , "correct",
        CountHighIntelligence = 4 , "well done",
        "Best Hiro"
    )

       

      With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
      FrankAT (Proud to be a Datanaut)

      • patkang's avatar
        patkang
        Helper I
        5 years ago

        FrankAT  you're awesome, thanks a lot!

        It is my first time using Switch() and it works really great.