Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

SQL query to DAX Measure conversion

I have the following SQL query that I have converted to DAX Measure   SELECT  RowNumber = ROW_NUMBER() OVER (PARTITION BY SSN ORDER BY EOMDate DESC) FROM [TransArchive].dbo.AGGR_Transaction_Chann...
DAX
PARTITION
ROWNUM
SQL
selimovd's avatar
selimovd
Most Valuable Professional
5 years ago

Hey Anonymous ,

 

it's not possible to nest FILTER functions. Just combine in one filter what you want to filter.

I guess you wanted something like this:

Index =
CALCULATE(
    COUNTROWS( 'Member Channel Utilization' ),
    FILTER(
        ALLSELECTED( 'Member Channel Utilization' ),
        'Member Channel Utilization'[Report Date] <= EARLIER( 'Member Channel Utilization'[Report Date] ) && 'Member Channel Utilization'[EDWCustomerID] = EARLIER( 'Member Channel Utilization'[EDWCustomerID] )
    )
)

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis