Forum Discussion

santiagomur's avatar
santiagomur
Icon for Resolver II rankResolver II
6 years ago
Solved

WHAT IF DYNAMIC COLUMN

I need to change ranges dynamically and compare them, the idea is to know what happens if we change the goals, how many people would meet or not. What I am trying to do is use "what if" to change the...
Need Help
Tips and Tricks
  • santiagomur's avatar
    santiagomur
    6 years ago

    thnk Marcus, mwegener 

     

    Its perfect just what I needed😀, and if now I want to know how many are 1, 2 or 3 on cards😅

santiagomur's avatar
santiagomur
Icon for Resolver II rankResolver II
6 years ago

thnk,  mwegener 

 

and you know if it is  way to made a measure using if.

 

what i need to do is something like this 

 

whatif selectedvalue

whatif1: 2 whatif2=5  whatif3=10

 

column1: between 0 and 1 =  level0

column1: between 2 and 4 =  level1

column1: between 5 and 9 = level2

 

            colmn1    level

emp1       1          

emp2       2

emp3       8

mwegener's avatar
mwegener
Icon for Most Valuable Professional rankMost Valuable Professional
6 years ago

Hi santiagomur ,

 

look at this.

PBIX

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

  • santiagomur's avatar
    santiagomur
    Icon for Resolver II rankResolver II
    6 years ago

    thnk Marcus, mwegener 

     

    Its perfect just what I needed😀, and if now I want to know how many are 1, 2 or 3 on cards😅

    • mwegener's avatar
      mwegener
      Icon for Most Valuable Professional rankMost Valuable Professional
      6 years ago
      Count Level 0 = COUNTROWS ( FILTER ( VALUES ( 'Table'[Emp] ), [level] = 0 ) )


      If I answered your question, please mark my post as solution, this will also help others.
      Please give Kudos for support.