How to get different measures in report

[emm980]

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]

Thanks so much to all! It is working very well.

[FreemanZ]

hi @emm980 

best way is to use field parameter to call for different measures one at a time:

https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters

[emm980]

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

[rajulshah]

@emm980 ,

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

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

[emm980]

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]

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

[rajulshah · Accepted solution]

@emm980 You can create this whenever you want.

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