Forum Discussion

charlineklapu's avatar
charlineklapu
Frequent Visitor
4 years ago
Solved

Measure filter min value per category

Hello all,   I want to have a measre which gives me the possibilty to filter for the min value (columns Days) within one case (column case). Data is used in direct query mode via analysis services....
DAX
measure
min
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi charlineklapu 
    You may try

    Flag =
VAR CurrentDate = 
    MAX ( Table[Date] )
VAR MinDaysValue =
    MINX (
        FILTER ( ALL( Table[Case] ), Table[Date] = CurrentDate ) ),
        [Days]
    )
RETURN
    [Days] = MinDaysValue

    Should return TRUE for min value

charlineklapu's avatar
charlineklapu
Frequent Visitor
4 years ago

First of all, thank you for your countinious help. 

 

But bad news, still not a solution for my problem. 

 

Now the error message: "The reultset of a query to external data source has exceeded the maximum allowed size of 1.000.000 rows." 

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

charlineklapu 

Can you please place this measure in your table and screenshot the results?

measure1 =
    COUNTROWS (
        CALCULATETABLE ( Table, ALLEXCEPT ( Table, Table[Case], Table[Date] ) )
    )
  • charlineklapu's avatar
    charlineklapu
    Frequent Visitor
    4 years ago

    Sorry, for the delay.

    Find the measure attached.

    Am I doing something wrong?

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    4 years ago

    charlineklapu 

    My friend. Please keep the four columns (case, date, name days) in the table

  • charlineklapu's avatar
    charlineklapu
    Frequent Visitor
    4 years ago

     This works.

     

    As soon as I also want to display "name", the error message appears.

     

    Is it due to my model? I have a fact table and numerous dimension tabels. But I am missing one dimension, thats why I am connecting a table "GW Aktuell" where I am grouping users (found in dimension table) into groups. And I want to show only one duration per group (multiple users out of fact table into one group).