Forum Discussion

SINGHTX9's avatar
SINGHTX9
Helper II
7 years ago
Solved

Capacity chart analysis

Hi    I want to run capacity chart analysis for my machine. So i have two machines Instrument A: Runs "CC" test type and has throughput of 1000 tests/hour and Instrument B: Runs "IA" test type an...
Need Help
  • Arentir's avatar
    Arentir
    7 years ago

    Hi SINGHTX9,

     

    See my solution attached, page 3

    https://1drv.ms/u/s!As5oZCclkGkWgSUKbcIgvNE_f5Qd

     

     

    I have created a new column [Type] in 'Selected Throughput' and created a relationship with [Test Type] in 'Actual Data' (I have noticed one row says 1200 instead of 1000 as in your post, beware of that)

     

    I have created a what if parameter like this

     

    The new measure is as follow:

    Capacity Utilized v2 =

    SUM('Actual data'[Number of Tests]) / ( SUM('Selected Throughput'[Selected Throughput]) * SELECTEDVALUE('Number of Instrument Selected'[Number of Instruments Selected]) * (1 + Parameter[Parameter Value]) )

     

    No need for separated measures for IA/CC and you have a parameter to increase the throughput.

     

    Hopes this helps

     

Arentir's avatar
Arentir
Resolver III
7 years ago

Hey SINGHTX9

 

Software is ScreenToGif, pretty handy for presentation indeed :)

I will try to have a look at your question later. Some thoughts for now:

You can have the priority added to your Final Table and Specimen distribution. Also better have a dimension table for Priority that would relate to all of the tables having priority field.

SINGHTX9's avatar
SINGHTX9
Helper II
7 years ago

Perfect!! Whenever you get the time

 

You are suggesting to create a new table with only priority field in it and then connect it to my specimen distribution table?

 

I was trying to create another table to calculate the  Turnaround Time. I want to know what % samples are processed within 1 hour and what % 2 hour etc, to achieve this would i have to create another table with TAT 1hr, 2hr etc and then how to write a DAX measure: SUM(COUNT OF ACCESSION) if TAT is <= value selected TAT time.

 

Also any ideas on how i can build the statistics utilization map as shown in the picture below.

 

Also are there some good tutorias where i can learn ideas how to make my dahboard look good in terms of presentation. (i didnt find any good video on enterprise DNA and youtube). Apologies if i m bothering you with too many questions, i m still new to power bi and have been the task by my manager to develop this dashboard for the team.

  • Arentir's avatar
    Arentir
    Resolver III
    7 years ago

    Hi SINGHTX9

    I did what I had in mind earlier. I have added Priority column to Final Table and Specimen Distribution (See dax table formula this is just slightly different).

     

    https://1drv.ms/u/s!As5oZCclkGkWgSdnqZgrEbLo4hod

     

    I have created a Priority Table and created a relationship to actual data, final table, specimen distribution. I find this cleaner so you just this Priority of this new table as a slicer and it will affect any of the table.

     

    You lost me with the TaT measure. I recommend that you open a new topic and try to simplify the model so you get more ideas from the community!

     

    For ressources not sure how much I can advertise on the forum so will send you a PM with some of my favs

     

    Arentir