Forum Discussion
Variance in Matrix
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?
2 Replies
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
Day Intelligence - Last day, last non continous day
https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5-5c3243d1f9Thanks 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.
