Forum Discussion

exe_binary's avatar
exe_binary
Frequent Visitor
1 year ago

Problem with Counting rows

Hello foks, I have a data like call_no part_no date_lt country 1234567 aa123 5/15/2023 le 1234567 bb456 5/21/2023 le 1234567 cc789 5/26/2023 le 456789 qq987 4/12/2024 ...
DAX
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi ALL,
Firstly SachinNandanwar  and Kedar_Pande  thank you for your solutions!
And exe_binary ,We can change the way to achieve your needs, your original DAX statement can be affected by the context of the columns in the matrix, he will determine the maximum value of each month and return, the following is the use of a measure of a way to achieve Hope you can help!

 

Max_Value_Measure = 
CALCULATE (
    COUNTROWS(Sheet1),  
    FILTER (
        Sheet1,
        Sheet1[date_lt] = CALCULATE (
            MAX(Sheet1[date_lt]),  
            ALLEXCEPT(Sheet1, Sheet1[call_no]) 
        )
    )
)

 

Hope it helps!

 

Best regards,
Community Support Team_ Tom Shen

 

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.