Forum Discussion

cottrera's avatar
cottrera
Post Prodigy
5 years ago
Solved

DAX Switch Help

Hi hopefully I explain this correctly   I have a table of completed property repairs in my report.  I have used DAX to perform a simple count of these completed  repairs (Repairs = COUNTROWS(Repair...
Need Help
  • cottrera's avatar
    cottrera
    5 years ago

    Hi yes 

     

    I was over complicating things and realised that I done need to switch/ look up a choice of many differenct percentages to apply to my table. In fact I only need to apply a choice of two percentages depending on my count results. See below.

     

    Calc Targets = IF(AND([Comp Repairs]>=1,[Comp Repairs]<=10),"0.05")&IF(AND([Comp Repairs]>=10,[Comp Repairs]<=40),"0.1")

cottrera's avatar
cottrera
Post Prodigy
5 years ago

Hello to all responders. I manged to resolve this issue myself by rethinking and applying a more simplified solution.

v-lili6-msft's avatar
v-lili6-msft
Community Support
5 years ago

hi  cottrera 

First, It's pleasant that your problem has been solved by yourself.

and for your case, I think there is another simple measure that try to use LOOKUPVALUE to get it:

Result = LOOKUPVALUE(Table_Percentages[%],Table_Percentages[Jobs],[Repairs])

 

Regards,

Lin