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,
I have to compare Actuals vs Targets (Planned Calls), but targets are based on specific period (ex. 01 Apr - 30 Sep) and vary by county. I have a date filter (coming from '$Time'[Date]) and Target slicer (from '$Targeting' table). Target values are based on that period, i.e. fixed, but when selecting earlier date on date slicer it shows a proportion. I would like to keep the targets for the whole target period, i.e. not changing even selecting different end date for example. I need something to match the selected period in date slicer and to catch the target inside, because there should be more than 1 target for the whole year for example. Tried with variables (working!) to narrow the calculation only for selected target, but is very slow and fails on some charts (RAM overload). Here is the sample of measure:
------------------------------------------------------------------------------------------------------------
PlannedCalls =
VAR StartDate = MIN ( '$Targeting'[Start Date] )
VAR EndDate = MIN ('$Targeting'[End Date])
RETURN
CALCULATE(SUM( CallsFact[Planned Calls]), '$Time'[Date] >= StartDate, '$Time'[Date] <= EndDate))
------------------------------------------------------------------------------------------------------------
Thank you in advance for ideas 🙂
Solved! Go to Solution.
@Anonymous ,
Click Format-> Edit interactions then click the block icon on the right-top of the visual so that the visual will not be effected by the visual you selected.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous ,
Click Format-> Edit interactions then click the block icon on the right-top of the visual so that the visual will not be effected by the visual you selected.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |