Forum Discussion

gustavjMC's avatar
gustavjMC
Frequent Visitor
5 years ago
Solved

Time range for time column

Hello!   I'm working on a report where i want my graph to be dependent on a start and stop time from another table.    In SQL my code would look something like this: SELECT [Value]             ...
  • gustavjMC's avatar
    gustavjMC
    5 years ago

    Thanks for replying!

    With this COUNTX function, it only counts the rows, but i want the actual rows in a table to be returned 🙂

gustavjMC's avatar
gustavjMC
Frequent Visitor
5 years ago

Thanks for replying!

With this COUNTX function, it only counts the rows, but i want the actual rows in a table to be returned 🙂

Element115's avatar
Element115
Icon for Memorable Member rankMemorable Member
5 years ago

if by ' but i want the actual rows in a table to be returned' you actually mean that you want the total count of rows from the table that is returned after applying the FILTER(), then, if I am not mistaken, you need to effect a filter transition programmatically, and the only way to do this in DAX is not the FILTER() function, but CALCULATE and CALCULATETABLE.

 

Rather than copy/paste a whole chapter, read chapter 5 from the book: 'The Definitive Guide to DAX,' 2nd edition,  by Marco Russo and Alberto Ferrari.  It's all explained there better than I could.