Forum Discussion

kaye123's avatar
kaye123
Frequent Visitor
3 years ago

Creating Visual Table w/ Calculated Measure from Multiple Query

Hi. I created several Calcultaed measure on different Table query. Now, I need to create a summary table which will provide me different numbers per cell as below. Each cell in Yield and Cost column have different Calculated Measure from different query. How should I set it up?

 

I am still new in PowerBI, I only know the drag and drop form of tables.

Appreciate help on this. Thanks!

StageYieldCost
FabFYieldFcost
ProbePyieldPcost
AssyAyieldAcost
TestTyieldTcost
Need Help

3 Replies

  • Umair_Aslam's avatar
    Umair_Aslam
    Helper I
    3 years ago

    Hi kaye123 

    you can use cards for it and set them in a tabular form.

    every card has shown different measure values and fixed them as a table.

    Like.

     

     

    • kaye123's avatar
      kaye123
      Frequent Visitor
      3 years ago

      Thanks for this. I have tried this. I am planning to setup multiple columns (around 30columns), replicating what i did in excel macro.  Cards will might be crowded with this setup. Are there any options?

       

       

      • Umair_Aslam's avatar
        Umair_Aslam
        Helper I
        3 years ago

        Hi kaye123 
        I had the same requirement and I handled that by using the card, but if you don't want to use the card try matrix visual. 
        Note: Power BI might be different from excel, what did you do in excel sometimes it can't be implemented in Power bi.
        That's why I prefer cards for this requirement and clients accept that.