Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
User | Count |
---|---|
73 | |
70 | |
38 | |
24 | |
23 |
User | Count |
---|---|
96 | |
93 | |
50 | |
41 | |
40 |