Measure: Sum of Grand Total of Another Column

[smtexcel]

Hi, for the life of me I can't figure this out, driving me nuts.

Trying to get the grand total of V500 Booked in every cell of Total V500 Booked, ultimately to calculate a percentage, but I think I can handle that part.

Something like this ->

V500 Booked is a measure and there are also quite a few slicers filtering the data.

This is where I am right now... TOTAL V500 Booked =calculate(SUMX(VALUES(Project_Data[V500_Contract]),[V500 by Fiscal Date]),ALLSELECTED(Fiscal_Slicers[Date]))
^which gives the correct grand total, but I want the value in every cell of the column.

V500 Booked =calculate([Sum of V500_Contract],USERELATIONSHIP(Project_Data[Booking],Fiscal_Calendar[Date]),ALL(Project_Data[DataView]))

Any help would be greatly appreciated.

 

[CountTepes]

Use the format:

Range(Cell(row1,Col),Cells(row2,Col))=V500Booked

That way you can fill a range with a value

 

[smtexcel]

Thanks for the response, couldn't figure out your suggestion though.

I was able to get the result I wanted with -> Sliced V500 Total =calculate([Sum of V500_Contract],ALLSELECTED())

But with the result came the red highlighted rows. This table is going to drive a pivot chart, so I don't want periods with 0/null Rev Recognized to show up.
It seems the allselected() severs the slicer functionality in that regard. Any idea how I can filter out these rows?

Something like this -> Sliced V500 Total =calculate([Sum of V500_Contract],ALLSELECTED(),ALLNOBLANKROW(Project_Data[Recognized Revenue]))
But doesnt work...