Forum Discussion

orghn's avatar
orghn
Icon for Helper I rankHelper I
4 years ago

Help on measure

Hi Everyone! I need to select only 1 lab and N products. I need to find the price per month of my product (my_price) and compare to the total_prod_price to find the difference (%) between my produ...
Need Help
orghn's avatar
orghn
Icon for Helper I rankHelper I
4 years ago

Hi Anonymous , thanks for your reply, maybe I explained wrong. I need this output:

My price should be the price for that month of the products from the selected Lab. 1500 should be for the first 3 rows and 1600 fir the last 3.

Whitewater100's avatar
Whitewater100
Icon for Solution Sage rankSolution Sage
4 years ago

Hi:

This gives you the price avg but in the grid it get's weird. Standing alone it is fine for getting your avg monthly product prices. 

Price Avg = AVERAGEX(SUMMARIZE('Price',
'Price'[Price],'Price'[Product], 'Price'[Month]),
'Price'[Price])
 
This one works in your grid but your  price table has aditional rows with very low  entries, which impact your avp price measures.
 
Price Avg Final = CALCULATE([Price Avg], REMOVEFILTERS())
 

 

  • orghn's avatar
    orghn
    Icon for Helper I rankHelper I
    4 years ago

    Yes, because I have many products for my lab, I only need the Lab and products selected

    • Whitewater100's avatar
      Whitewater100
      Icon for Solution Sage rankSolution Sage
      4 years ago

      Hi:

      Did you use the solution file? Thanks..

      • orghn's avatar
        orghn
        Icon for Helper I rankHelper I
        4 years ago

        Yes, I´m working with the attached file but I need to see all the products but only my price on the first column