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.
Good Day All,
I have the following formula to calculate Standard Deviation with a virtual table:
StdDev_EquipIDRatio Allexcept =
VAR _table = SUMMARIZE(FILTER(GeneralStatistics, GeneralStatistics[TotalVisits] <> 0),[Date], [GSIndex],
"_EquipIDRatio",[EquipmentIDRatio])
RETURN
STDEVX.P(_table,[_EquipIDRatio])
I want this formula to ignore any Date Filter contexts on my report page (Calendar, Calendar[Date]).
Figured I should use the ALLEXCEPT function, but am unable to get the syntax correct to make it work.
Hoping someone can advise where the ALLEXCEPT function fits into the Summarize statement. My [TotalVisits] filter is used to eliminate NaN errors.
Thanks much!
Solved! Go to Solution.
@rsbin - Should be along the lines of:
StdDev_EquipIDRatio Allexcept =
VAR _table = SUMMARIZE(FILTER(ALLEXCEPT(GeneralStatistics,...), GeneralStatistics[TotalVisits] <> 0),[Date], [GSIndex], "_EquipIDRatio",[EquipmentIDRatio])
RETURN
STDEVX.P(_table,[_EquipIDRatio])
The ... is where you would list your columns that you want to keep filters on.
@rsbin - Should be along the lines of:
StdDev_EquipIDRatio Allexcept =
VAR _table = SUMMARIZE(FILTER(ALLEXCEPT(GeneralStatistics,...), GeneralStatistics[TotalVisits] <> 0),[Date], [GSIndex], "_EquipIDRatio",[EquipmentIDRatio])
RETURN
STDEVX.P(_table,[_EquipIDRatio])
The ... is where you would list your columns that you want to keep filters on.
Kudos my friend. Thank you much!
StdDev_EquipIDRatio Allexcept =
VAR _table = SUMMARIZE (FILTER(ALLEXCEPT(GeneralStatistics, GeneralStatistics[Date]), GeneralStatistics[TotalVisits] <> 0),
'Calendar'[Date], [GSIndex],
"_EquipIDRatio",[EquipmentIDRatio])
RETURN
STDEVX.P(_table,[_EquipIDRatio])
Had to make one little tweak though. Had to adjust [Date] to 'Calendar'[Date]. Not sure why, but seems to be working
Anyhow, thanks again for the quick response.
Best Regards,
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 |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |