Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
Just need to tweak my dax calc guide me to get results shown in the figure below
Solved! Go to 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
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
@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
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
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
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
@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
Hi Prateek,
Im experiencing syntax error
Thanks
kng
Whats the error? Can you upload screenshot of error?
Hi Prateek,
Find above error snapshot when I apply code
Thanks
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |