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.
Hello everyone,
I'm getting nuts trying to solve the following.
We need to know how many people signed the form each month and how many people have we seen in total in that month.
For the first requeriment, I solved it using:
Signed People=
Solved! Go to Solution.
Hello @okusai3000
Try this:
Form Not Signed =
VAR _SignFormDateChek =
FILTER(dtPatient,
ISBLANK(dtPatient[[CON_VIS_CLI]) || dtPatient[[CON_VIS_CLI] > dtPatient[Vistit Date]
)
VAR _RowCount =
CALCULATE(DISTINCTCOUNT(dtPatient[PATIENT_ID]),_SignFormDateChek
)
RETURN
_RowCount
Cheers!
Vivek
If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂
https://www.vivran.in/
Connect on LinkedIn
Hello @okusai3000
Try this:
Form Not Signed =
VAR _SignFormDateChek =
FILTER(dtPatient,
ISBLANK(dtPatient[[CON_VIS_CLI]) || dtPatient[[CON_VIS_CLI] > dtPatient[Vistit Date]
)
VAR _RowCount =
CALCULATE(DISTINCTCOUNT(dtPatient[PATIENT_ID]),_SignFormDateChek
)
RETURN
_RowCount
Cheers!
Vivek
If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂
https://www.vivran.in/
Connect on LinkedIn
Sir, I simply LOVE YOU.
That was the solution.. Thank you so much.
Form Not Signed =
VAR _SignFormDateChek =
FILTER(dtPatient,
ISBLANK(dtPatient[[CON_VIS_CLI]) || dtPatient[[CON_VIS_CLI] >= dtPatient[Vistit Date]
)
VAR _RowCount =
CALCULATE(DISTINCTCOUNT(dtPatient[PATIENT_ID]),_SignFormDateChek
)
RETURN
_RowCount
Hi @okusai3000
Could you show a simple example and expected result to make me clear?
Best Regards
Maggie
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |