Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Measure for Line diagramm

Hi!   I am kind of new to PowerBI and I wanted to do a ratio. So I figured I can divide somehow like this:   Test = 1 - DIVIDE(CALCULATE(COUNT('Table1'[A]), FILTER('Table1','Table1'[A] = "Closed...
  • Tanushree_Kapse's avatar
    Tanushree_Kapse
    5 years ago

    Hi Anonymous ,

    You can create a Running Total measures for them: For ex:

    Test=
    Var A= CALCULATE(CALCULATE(COUNT('Table1'[A]), FILTER('Table1','Table1'[A] = "Closed")), FILTER(ALLSELECTED(Table1[Date]), Date <= MAX( Table[Date])))

    Var B= CALCULATE(COUNT('Table1'[B]), FILTER(ALLSELECTED(Table1[Date]), Date <= MAX( Table[Date])))

    Return (1- DIVIDE(A,B))

     

    I hope this helps!

Tanushree_Kapse's avatar
Tanushree_Kapse
Icon for Impactful Individual rankImpactful Individual
5 years ago

Hi Anonymous ,

You can create a Running Total measures for them: For ex:

Test=
Var A= CALCULATE(CALCULATE(COUNT('Table1'[A]), FILTER('Table1','Table1'[A] = "Closed")), FILTER(ALLSELECTED(Table1[Date]), Date <= MAX( Table[Date])))

Var B= CALCULATE(COUNT('Table1'[B]), FILTER(ALLSELECTED(Table1[Date]), Date <= MAX( Table[Date])))

Return (1- DIVIDE(A,B))

 

I hope this helps!