I need some help badly i have been stuck on this for a week now.
I need a way of making this dynamic so when i change the slicers at the top the table looks at the new mean and standard deviation values for that selection.
The way i do it now is using a calculated table which doesn’t update when slicers are changed therefore i need to re write this as a virtual table in DAX formula.
Normal Distribution =
//This is the code i was using. The issue with this is it doesn’t look at the filtered data it looks at the raw table.
//VAR MinNumber = FLOOR([X-3σ],1)
//VAR MaxNumber = CEILING([X+3σ],1)
//All i need is the info i see on my report page in the X-3σ and X+3σ cards. Obviously i typed this in to test but its perfect i just need to write this some how so it picks up those values. This is where i need your help.
VAR MinNumber = -231 // X-3σ card value
VAR MaxNumber = 1307 // X+3σ card value
CALENDAR ( MinNumber, MaxNumber ),
“X”, INT ( [Date] )
Sigma Test2.pbix (453.2 KB)