Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

DAX Measure for Active Contracts based on a value

Hello!    I'm new to Power BI so please ask if what I'm trying to do is not understandable.    I have a table with Contracts and I've made a measure to show me the active contracts from day to da...
DAX
measure
Motasem_Yakhola's avatar
Motasem_Yakhola
Icon for Helper I rankHelper I
6 years ago

Hello Siljewiehauge,

 

You can change your measure to be like below:

Day to day = calculate(COUNTROWS(Contracts),filter(ALL(Contracts[Start Date]),Contracts[Start Date]<=MAX(Contracts[Start Date])))
 
So by adding the measure to values and dates to axis you will get below visual:
 
 
 If you want to get line for each contract type; just add contract type to legend and you will get below chart
 
Hope thats answering your question 🙂
 
Please don't hesitate to ask if anything else.
Best wishes.
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
     

    Hello, and thank you! I've already done that, with the measure that I have. And I have the Active Contracts in a line diagram, it's working.

     

    When I try to add Grid Owner Name to legend, it's not working. Somehow the line flattens out.

    And anyway I would need one line for total, than one line for each of those. 

     

    So I thought if I could create one measure for total active contracts, as I already have; 

    then one measure that used the same calculation, but only based on rows with the correct Grid owner name? Is that possible? 

     

     

     

     

    • Motasem_Yakhola's avatar
      Motasem_Yakhola
      Icon for Helper I rankHelper I
      6 years ago

      Unfortunetaly, line chart can have only one measure.

       

      However, there is a hack to do that:

      1 . In Power Query window: copy you query

      2 . Replace each contract type with the word "All"

      3 . Append quiries together.

       

      By doing those steps you will have doublicate data in your table with contract type called All 

       

      Hope that's helps you.

      Best wishes.

       

      ----------------------------------------------

      Did I answer your question? Mark my post as a solution!