Converting a calc in Tableau to one in Power BI

[MarcUrdang]

Hi

Please can you help ... not sure how to best describe this ...

The talbe has Stock on Hand and a Forecast Qty field along with othes such as Warehouse codes etc. I am trying to get a % of Forecast to Inventory.  

eg. if you have two warhouses (or more for that matter) and only two have inventory for a particular item code but only one of those has a Forecasted amount:

warehouse 1 = Forecast 3 

warehouse 2 = Forecast 11

I want to get a % for that particular day/date ie 3/11 ... I have used the calc below which gives me the 14 .. but I then have to put the 'warehouse' field into the axis in order to see the '3'  ... and of course I want to build it into the calc to return the %

Not sure is this makes any sense.

thx

Marc

Calc = if(sum('Ops Data'[aQtyEXTRACT Stock on Hand])<>BLANK(),Calculate(sum('Ops Data'[aQtyEXTRACT Forecast Qty])))

[v-xiaotang]

Hi @MarcUrdang 

Could you share your data and the expected outcome (with calculation formula) in Excel?  Thanks.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.