Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello All,
My question is probably answered somewhere but I can't find it.
I created a measure like this:
CountFailureInThePast10Weeks =
CALCULATE(
[Count Tasks Executions],
ALLEXCEPT( TASK_HISTORY_VW, TASK_HISTORY_VW[STATE], TASKS_VW[NAME], TASKS_VW[SCHEMA_NAME] ,Datum[Past10Weeks], TASK_HISTORY_VW[DATABASE_NAME])
)
The goal is to have the number of failures in the past 10 weeks for a task.
But I want to keep this number not filtered in a Visual filtered by date.
So, without the measure in the visual, i get 5 lines, the 5 failure of the last 7 days (this is a filter in the visual). And when I add the measure that ignore the date filter, it add lines.
I need, the measure calculated on 10 weeks history in a visual with only the tasks from last week.
How I can achieve that ?
Thanks 😄
Unfortunatly it doesn't works.
Initial state, my vis is filtered on Pastweek = true :
After including the measure
My goal is to keep image 1 with value from measure on image 2
@Thomas_Daubert ,You can achieve this by using the REMOVEFILTERS function to remove the date filter context from the calculation
CountFailureInThePast10Weeks =
CALCULATE(
[Count Tasks Executions],
ALLEXCEPT(TASK_HISTORY_VW, TASK_HISTORY_VW[STATE], TASKS_VW[NAME], TASKS_VW[SCHEMA_NAME], TASK_HISTORY_VW[DATABASE_NAME]),
REMOVEFILTERS(Datum[Past10Weeks])
)
Proud to be a Super User! |
|
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
111 | |
105 | |
105 | |
88 | |
61 |
User | Count |
---|---|
165 | |
133 | |
132 | |
95 | |
86 |