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.
This is my expression:
CALCULATE (
SUM ( WHourOAI[WCalWorkingHour] ),
FILTER (
WHourOAI,
FORMAT ( WHourOAI[TRANSDATE], "dd MMMM, yyyy" )
> FORMAT ( "13 July, 2015", "dd MMMM, yyyy" )
&& FORMAT ( WHourOAI[TRANSDATE], "dd MMMM, yyyy" )
< FORMAT ( TODAY (), "dd MMMM, yyyy" )
)
)
It's working but not shosing the correct values, If I apply a month filter and check for the sum of feb month it shows only 8 i.e. unique or distinct value. but i want to sum all the values because in my table it contains only 1 record on a single date. How to remove this default filter??
Thanks for your time.
Not entirely sure, but it sounds like you want an ALL clause like:
CALCULATE ( SUM ( WHourOAI[WCalWorkingHour] ), ALL(WHourOAI), FILTER ( WHourOAI, FORMAT ( WHourOAI[TRANSDATE], "dd MMMM, yyyy" ) > FORMAT ( "13 July, 2015", "dd MMMM, yyyy" ) && FORMAT ( WHourOAI[TRANSDATE], "dd MMMM, yyyy" ) < FORMAT ( TODAY (), "dd MMMM, yyyy" ) ) )
Tough to say without sample data and expected output.
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 |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |