Newbie Question - struggling to refer to values in another table
Hi I have two tables Table 1 - Production Contains record of products booked into the warehouse Timestamp Product Quantity 20/07/2021 13:45 ABC 2 20/07/2021 14:12 XYZ 32 20/07/2021 16:38 ABC 54 Table 2 - Weekly Targets Simply contains the target production per week Week Number Product Target 28 ABC 300 29 ABC 380 30 ABC 410 28 XYZ 60 29 XYZ 130 30 XYZ 110 I'm trying to display a series of guages - one for each product and for each day of the week, showing the numbers produced each day against the daily target based on the weekly target / 5 (So in week 28 we need to make 60 units of ABC each day to meet out target) I've manage to create the guages for each day of the week and each product from the 'Production' table I've also got the filters working so that I only use the production quantities for this week in each guage I can also - add a column to the 'Weekly Targets' table that contains the [Daily Target] - add a colum to the 'Production' Table that contains the Week Number for that entry but now I can't fathom out how to use the new 'Weekly Target'[Daily Target] values to set the target in the guage I feel a bit dim... Thanks ChrisTargets in KPI
Hi all, I am trying to build a KPI card, but stuggeling to connect my data model with an external target or maximum value for the distinct entries in my data. here is a view of my sample external data : Origin Name 1-W Target Ameenpur 0.0402 Asansol Depot 0.1967 Atmakuru 0.6037 Aurangabad Depot 0.2831 Bangalore-Bidadi-DPG 0.3301 I have relationship as: The measure I am giving KPI value for : 1-Way Distribution = DIVIDE( CALCULATE([Shipments],'Prototype Modeling_Freight'[Load Category]="1-Way"), CALCULATE([Shipments]) ,BLANK()) Here is a link to screen recording to my problem statement Thank you
