Forum Discussion

emm980's avatar
emm980
New Member
3 years ago
Solved

How to get different measures in report

Hi dears, I'm new both on PBI modeling and this great community!

 

I'm in charge to develop a new report showing the inventory level both in pcs and value but only one value at time.

 

I've the following table:

 

PRODUCT     WAREHOUSE      QTY      VAL
Bike               Canada                500     5000$

Cars               USA                       50   12000$

 

and so on.

 

How can get a report showing alternatively QTY and VAL?

 

I've tried to use the PARAMETER by selecting FIELDS instead of MEASURES but I only retrieve the LABEL (QTY/VAL) instead of the current measure.

 

Could you kindly explain me what is the best way to manage this issue? Have you any link "graphical" to show me the way since I'm a newbie?

 

Thanks in advance

  • emm980 You can create this whenever you want.

    Measures doesn't depend on the position of where it is.

7 Replies

  • rajulshah's avatar
    rajulshah
    Icon for Resident Rockstar rankResident Rockstar

    emm980 ,

     

    I believe you want something as shown in the blog here.

    Please let me know if this is not what you want.

    • emm980's avatar
      emm980
      New Member

      Thanks rajulshah. It is just what I would reproduce. However I'm bit confused about this section

       

      where have I to create these new measures? In table DTDates or FTSales (following the example)?

      • emm980's avatar
        emm980
        New Member

        ok... I've better read... in FTSales. And, what about the "Dynamic Measure" where have I to insert? In the created slicer?

    • emm980's avatar
      emm980
      New Member

      thanks FreemanZ... I've just followed this link before edit my first post!! Only obtained to have in any row Qty o Val!!