Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Agregate and filter

Hi Power BI Community   I have a transaction table below. I need to create a report filtered by SALE DATE, and PRODUCT ID. In the report i want to show: 1- The number of transactions including t...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    I actually found another solution.

     

    I have 2 tables : 1 sale detail and 1 sale header. 

    I found a way to create a measure in sale detail that points to the sale header using USERRELATIONSHIP.

     

    It works.

    Thanks

    F

Anonymous's avatar
Anonymous
Not applicable
8 years ago

I would like to create a table filtered by date (SALE_DATE) and product (PRODUCT ID)

 

The table would include Store ID in lines and in columns :

- Nb of transactions (that's DISTINCTCOUNT(TICKET ID)

- Total amount of products filtered (SUMX(SALE AMOUNT * SALE QUANTITY)

- Total value of transactions that include the filtered product (the one measure i need help on)

 

Thanks a million for your help

ChandeepChhabra's avatar
ChandeepChhabra
Icon for Impactful Individual rankImpactful Individual
8 years ago

Anonymous Can you share a snapshot of the output ? Especially for the last measure

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    I actually found another solution.

     

    I have 2 tables : 1 sale detail and 1 sale header. 

    I found a way to create a measure in sale detail that points to the sale header using USERRELATIONSHIP.

     

    It works.

    Thanks

    F