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)

amitchandak's avatar
amitchandak
Super User
5 years ago

patkang , Try a measure like


if( calculate(Countrows(Table1), filter(Table,Table[Intelligence] = "High"), allexcept(Table, Table[positionID])) <=2 , "risky", "Non Risky")