Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I have a issue I can't seem to figure out myself. I have a measure that counts number of rows from my table for the last two weeks from today. Then I use a filter to count only rows that contains certain countries. This works exactly as expected.
Then I want to do the exact same thing for rolling last two complete weeks. Counting works fine using this measure:
Last two complete weeks =
CALCULATE(
COUNTROWS(
Table1
),
Date[RelativeISOWeekNumber] in {-1, -2}
)
The difference comes when I use this measure to count the number of rows with textfilter..
Filtered Complete two weeks =
VAR _ENG = CALCULATE([Last two complete weeks],
FILTER(
Table1,
LEFT(Table1[Description], 3) = "Eng")
)
VAR _WA = CALCULATE([Last two complete weeks],
FILTER(
Table1,
LEFT(Table1[Description], 3) = "Wal")
)
Return
_ENG + _WA
the only thing that I've changed from rolling last two weeks is the date filter. The working one I'm using using this:
Solved! Go to Solution.
try this
Filtered Complete two weeks =
VAR _ENG = CALCULATE([Last two complete weeks],
FILTER(ALL(
Table1),
LEFT(Table1[Description], 3) = "Eng")
)
VAR _WA = CALCULATE([Last two complete weeks],
FILTER(ALL(
Table1),
LEFT(Table1[Description], 3) = "Wal")
)
Return
_ENG + _WA
try this
Filtered Complete two weeks =
VAR _ENG = CALCULATE([Last two complete weeks],
FILTER(ALL(
Table1),
LEFT(Table1[Description], 3) = "Eng")
)
VAR _WA = CALCULATE([Last two complete weeks],
FILTER(ALL(
Table1),
LEFT(Table1[Description], 3) = "Wal")
)
Return
_ENG + _WA
User | Count |
---|---|
86 | |
82 | |
68 | |
66 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |