Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Line chart

Hi there,    I am new to Power BI and would like some help on the following topic. I would like to create a line chart from the following (Example) data:   System name       Scope           Clos...
Need Help
Show and Tell
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    6 years ago

    Try

     

    Measure = CALCULATE(COUNT(systemclose[System name]),FILTER('systemclose',systemclose[Close date]<=max('Date'[Date])),systemclose[Scope]="In Scope")

    file is attached

     

     

amitchandak's avatar
amitchandak
Super User
6 years ago

Try

 

Measure = CALCULATE(COUNT(systemclose[System name]),FILTER('systemclose',systemclose[Close date]<=max('Date'[Date])),systemclose[Scope]="In Scope")

file is attached