Forum Discussion

obriaincian's avatar
obriaincian
Resolver I
3 years ago
Solved

Dax Calculated column with calculation

Hi All,   My dataset looks like this   Company            ID                      Status                        Submitted         Apple 11 TD Complete   Apple 11 TD Complete Sub...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    Hi,

    Please check the below picture and the attached pbix file.

     

     

    New Table =
ADDCOLUMNS (
    DISTINCT ( Data[Company] ),
    "Complete", CALCULATE ( COUNTROWS ( DISTINCT ( Data[ID] ) ), Data[Status] = "TD Complete" ),
    "Complete-Submitted",
        CALCULATE ( COUNTROWS ( DISTINCT ( Data[ID] ) ), Data[Status] = "TD Complete" )
            - CALCULATE (
                COUNTROWS ( DISTINCT ( Data[ID] ) ),
                Data[Status] = "TD Complete",
                Data[Submitted] = "Submitted"
            )
)
Jihwan_Kim's avatar
Jihwan_Kim
Super User
3 years ago

Hi,

Please check the below picture and the attached pbix file.

 

 

New Table =
ADDCOLUMNS (
    DISTINCT ( Data[Company] ),
    "Complete", CALCULATE ( COUNTROWS ( DISTINCT ( Data[ID] ) ), Data[Status] = "TD Complete" ),
    "Complete-Submitted",
        CALCULATE ( COUNTROWS ( DISTINCT ( Data[ID] ) ), Data[Status] = "TD Complete" )
            - CALCULATE (
                COUNTROWS ( DISTINCT ( Data[ID] ) ),
                Data[Status] = "TD Complete",
                Data[Submitted] = "Submitted"
            )
)