Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
Dear Colleagues!!! How can I make the matrix visual calculate right without a filter?
I have a matrix and I´m using 2 filters (Slicer with dates and Chiclet slicer with weeks) If I chose a range of time including 4 weeks the matrix table show incorrect values and when I click on the weeks (2 cond slicer) I get correct Values...Can somebody tell me why please!!!
Incorrect Values
Correct Values....
Solved! Go to Solution.
Solved!!! I dont know what exactly happen but I realized that my DAX dont work if there are "blanks" in between, meaning that blanks interfiere some how in the formula calculation (I dont know what happen exactly in there)... In this case I used the visual level filter and let blanks out of this operation and the problem is gone!
Thanks to my self XD
Solved!!! I dont know what exactly happen but I realized that my DAX dont work if there are "blanks" in between, meaning that blanks interfiere some how in the formula calculation (I dont know what happen exactly in there)... In this case I used the visual level filter and let blanks out of this operation and the problem is gone!
Thanks to my self XD
 
					
				
				
			
		
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
 
            | User | Count | 
|---|---|
| 84 | |
| 49 | |
| 36 | |
| 31 | |
| 30 |