Grouping and Sub-queries dax

Asked Nov 17 '17 at 00:52

Active Nov 17 '17 at 12:09

Viewed 102 times

I am bringing detailed data to Tabular cube(Model is denormalized..One table in model having various attributes A,B,C,D and measures).I want to calculate some measures(Sales, Unit Price) by grouping on A.B.C. On top of that i want to calculate few measures on grouping of B.C.D and first level measures(sales,unit price) will be used to calculate the second level(new) measures..This is what we can achieve by using sub queries in sql. How to write them in dax.

Evaluate GROUPBY( ADDCOLUMNS( GROUPBY(

EMP,
    EMP[Visitid],EMP[Identifier],EMP[Specifier],EMP[SystemId],EMP[Login]
    ) ,"Status", IF([Min_ResponseId]=88,"N","Y"),
              "Resolved", [Max_StatusId],
     "Max_createdate",Max(EMP[CreateDate])
     ),
        EMP[Login],EMP[Identifier],EMP[Specifier],
    "Accepted",MAXX(  CURRENTGROUP (), IF([Resolved]=7 && [Status]="Y",1,0) )
    )

edited Nov 17 '17 at 12:09

asked Nov 17 '17 at 00:52

Satyabrat Nayak

Please provide some code to show what you've attempted (at the very least). – Karl Hill Nov 17 '17 at 00:53
Sql - Select Sum(yy) from A group by x,y,z - result stored in temp table – Satyabrat Nayak Nov 17 '17 at 11:57

Grouping and Sub-queries dax

0 Answers0