Dax Tweak

[Anonymous]

Hi All,

Just need to tweak my dax calc guide me to get results shown in the figure below

 

[prateekraina · Accepted solution]

Hi @Anonymous,

Try below DAX:

Private Evnt =
CALCULATE (
    COUNT ( EVNT_SCH_F[EVNT_SCH_ID] ),
    FILTER (
        [YOUR TABLE NAME],
        EVNT_SCH_D[DLVR_TYPE_NM] = "Private"
            && EVNT_SCH_D[SCH_STAT_CD] = "DONE"
    )
)

Private Evnt =
CALCULATE (
    COUNT ( EVNT_SCH_F[EVNT_SCH_ID] ),
    FILTER (
        [YOUR TABLE NAME],
        EVNT_SCH_D[DLVR_TYPE_NM] = "Public"
            && EVNT_SCH_D[SCH_STAT_CD] = "DONE"
    )
)

Replace [Your Table Name] with your actual table name in which these columns are present. That should work.

Prateek Raina

[Anonymous · Accepted solution]

Hi Prateek,

Its working thanks for your solution but in current scenario, it is excluding blanks should I use instead Filter  ISBlank function for including blanks.

Thanks

[prateekraina]

Hi @Anonymous,

Try below DAX:

Private Evnt= CALCULATE(COUNT(EVNT_SCH_F[EVNT_SCH_ID]),EVNT_SCH_D[DLVR_TYPE_NM]="Private" && EVNT_SCH_D[SCH_STAT_CD] = "DONE")

 

Public Evnt= CALCULATE(COUNT(EVNT_SCH_F[EVNT_SCH_ID]),EVNT_SCH_D[DLVR_TYPE_NM]="Public" && EVNT_SCH_D[SCH_STAT_CD] = "DONE")

 I hope there are no syntatical errors as i have just typed in between your code 🙂

Prateek Raina

[prateekraina · Accepted solution]

Hi @Anonymous,

Try below DAX:

Private Evnt =
CALCULATE (
    COUNT ( EVNT_SCH_F[EVNT_SCH_ID] ),
    FILTER (
        [YOUR TABLE NAME],
        EVNT_SCH_D[DLVR_TYPE_NM] = "Private"
            && EVNT_SCH_D[SCH_STAT_CD] = "DONE"
    )
)

Private Evnt =
CALCULATE (
    COUNT ( EVNT_SCH_F[EVNT_SCH_ID] ),
    FILTER (
        [YOUR TABLE NAME],
        EVNT_SCH_D[DLVR_TYPE_NM] = "Public"
            && EVNT_SCH_D[SCH_STAT_CD] = "DONE"
    )
)

Replace [Your Table Name] with your actual table name in which these columns are present. That should work.

Prateek Raina

[Anonymous · Accepted solution]

Hi Prateek,

Its working thanks for your solution but in current scenario, it is excluding blanks should I use instead Filter  ISBlank function for including blanks.

Thanks

[prateekraina · Accepted solution]

@Anonymous

You need to add condition for including blank also then. Normally its written like [Field] = BLANK()

Also, kindly thumbs up my answer if i have resolved your problem 🙂

Prateek Raina

[Anonymous]

Hi Prateek,

Im experiencing syntax error 

Thanks

kng

[prateekraina]

Whats the error? Can you upload screenshot of error?

[Anonymous]

Hi Prateek,

Find above error snapshot when I apply code

Thanks