Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Help with a measure: Counting rows.

Hello, I need some halp with a simple DAX query.   I have a table of facts that contains, amongst other things, a created date column ([credte]), a closed date column ([clomatdte]) and a fee earne...
Need Help
  • v-deddai1-msft's avatar
    v-deddai1-msft
    5 years ago

    Hi Anonymous ,

     

    Would you please try to use the following measure:

    Open Matters =
CALCULATE (
    COUNTROWS ( lgmattrr ),
    FILTER ( lgmattrr, ISBLANK ( lgmattrr[clomatdte] ) ),
    ALL ( 'Date Table' )
)

     

    If this post help, please consider accept it as the solution to help other member find it more quickly.

     

    Best Regards,

    Dedmon Dai

jdbuchanan71's avatar
jdbuchanan71
Super User
5 years ago

Anonymous 

Does this give you what you are looking for?

 

All Time Open =
CALCULATE ( [Open Matters], ALL ( Date ) )

This simply calculates your [Open Matters] measure as if there were no filters on the date table.

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

This gives me the same result as the Open Matters measure unfortunately.

 

  • jdbuchanan71's avatar
    jdbuchanan71
    Super User
    5 years ago

    Anonymous 

    I'm not sure what the problem is.  Can you perhaps share a deidentified version of your pbix?