I have a visual where I am trying to show the standard deviation value every day for each row, not just the 'result' or grand total if you will. The measure is: STDEVX.P(Confidential,[%Positive]) - (in case you're wondering, even if I use STDEVX.S, the result total is the same but the individual row results are NaN values).
Each field is also a measure - no date filters. The Date column contains the date from a Dax-generated calendar, as well as field items from another related table (Confidential). Basically, the only 'filter' for the entire visual is the Date itself.
My question is: what do I need to do to provide/calculate a STDev result for each row. Note: if a column contains blanks, it's supposed to as we are only looking at Total Cases, total positive/inconclusive cases. Your help is very much appreciated - and yes, I'm a newbie to PBI
Each field is also a measure - no date filters. The Date column contains the date from a Dax-generated calendar, as well as field items from another related table (Confidential). Basically, the only 'filter' for the entire visual is the Date itself.
My question is: what do I need to do to provide/calculate a STDev result for each row. Note: if a column contains blanks, it's supposed to as we are only looking at Total Cases, total positive/inconclusive cases. Your help is very much appreciated - and yes, I'm a newbie to PBI
