Forum Discussion
Solved
Subtotal includes blank values
Hello, I need some help getting the subtotal to show the correct value in a Table Matrix by using DAX if possible, rather than using the filter on the page. Below is a screenshot of my expect...
Hi,
Write this measure
Hours Blank = SUMX(FILTER(VALUES(Jobs[Job Number]),[Technician Labor Hours]<>BLANK()),[All Labor Hours])Hope this helps.
Hi Leh
Both are links to SampleData.xlsx