Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

DAX Formula Help

Hi  I am new to DAX and I would like to know how I can fix this   I have the following sample dataset  ID  X Y Length  1 0.321 False  100 1 0.375 False  150 1 0.425 False  ...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    Anonymous 

     

    You can use these MEASURES

     

    Predominant X =
CALCULATE (
    MAX ( Table1[X] ),
    FILTER ( table1, Table1[Length] = MAX ( Table1[Length] ) )
)

     

    Length_ = CALCULATE(sum(Table1[Length]),Table1[Y]=true)

     

Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
7 years ago

Anonymous 

 

You can use these MEASURES

 

Predominant X =
CALCULATE (
    MAX ( Table1[X] ),
    FILTER ( table1, Table1[Length] = MAX ( Table1[Length] ) )
)

 

Length_ = CALCULATE(sum(Table1[Length]),Table1[Y]=true)

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks Zubair for your help, it is really appreciated :)