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")

amitchandak's avatar
amitchandak
Super User
5 years ago

cottrera , The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Appreciate your Kudos.