Variance in Matrix

[Ejykso]

Hi All,

I'm stuck and will appreciate it if someone can help me with this. 

I have a matrix coming up as this:

End of Week	19.2023		12.2.2023		Total
Period	Vol		Vol		Vol
1-7 Days	20		10		30
8-14 Days	20		10		30
15-21 Days	10		20		30
21days +	55		30		85
Total	105		70		175

The dates in the matrix all came from the same column rundate and the values came from Countrows(datatable) which gives the total count. When this total is put in the values section of the matrix, it goes to the appropriate section as seen in the table. The issue is that I'm trying to have a variance of the values of the two dates instead of the total that the matrix has put for me. It would have been good if there's something like enable Variance just like we have subtotals and Grandtotals.  How do I get the variance of these values?

[amitchandak]

@Ejykso , You can use isinscope to replace grand total/subtotal with variance measure

https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/

for variance

Power BI Abstract Thesis: How to use two Date/Period slicers

https://youtu.be/WSeZr_-MiTg

Day Intelligence - Last day, last non continous day
https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5-5c324...

[Ejykso]

Thanks amitchandak, However, the link is not opening anymore and I couldn't get to see how to replace this built-in subtotals with variance.  I'll appreciate it if you could give an example using the table above.