Forum Discussion
Remove filter off specific Column on Matrix
Just wanted to provide a solution to my own post!
There is a built in Total YTD Function that I used. Works like a charm for anyone trying to do something similar
TOTALYTD(SUM(Column),DimDate[Year Month],ALL(DimDate),"10/31")
Anonymous - Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
That being said, if I understand what you are asking, it probably involves ALL or ALLEXCEPT.