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,
I've had a hunt for a solution, though starting from a pretty limied level of knowledge which doesn't help...
I have the following measure applied to my data, which gives me the accompanying Table. I got these values even though I've only specified "FAI", so suspect that's not helping things. The '0' is added to ensure the table adds a 0 when there's a null value
Solved! Go to Solution.
Hi @Anonymous ,
To use this measure should work.
To Date = VAR this_month = FORMAT ( TODAY (), "mm-yyyy" ) RETURN CALCULATE ( COUNTAX ( 'IR H&S Incident Register', 'IR H&S Incident Register'[Classification] = "FAI" ), FILTER ( 'IR H&S Incident Register', FORMAT ( 'IR H&S Incident Register'[date], "mm-yyyy" ) = thsi_month ) ) + 0
Hi @Anonymous ,
To use this measure should work.
To Date = VAR this_month = FORMAT ( TODAY (), "mm-yyyy" ) RETURN CALCULATE ( COUNTAX ( 'IR H&S Incident Register', 'IR H&S Incident Register'[Classification] = "FAI" ), FILTER ( 'IR H&S Incident Register', FORMAT ( 'IR H&S Incident Register'[date], "mm-yyyy" ) = thsi_month ) ) + 0
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 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |