Forum Discussion

anne-sophie's avatar
anne-sophie
Frequent Visitor
5 years ago

Multisteps dynamic countings

Hello,   Here is my today's headlock. I have a table, of, let's say, orders and products, and attributes: Order Order attribute 1 Order attribute 2 Product Product attribute 1 O1 OA1.v...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi anne-sophie ,

 

Actually, the information you have provided is not making the problem clear to me.

Please explain to me in detail about how to get these fields :Nb Prod per Order / number of order / number of sale or provide me with more details about your table and your problem and share me with your pbix file after removing sensitive data.

 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • anne-sophie's avatar
    anne-sophie
    Frequent Visitor
    5 years ago

    Hello Eyelyn,

    You are right, I should explain my case better.

    I've shared a .pibx : here

    I have a table (Tableau1) with products made of items. 

    I have another table (Tableau2) with also products and items, but in this case the number of items per products can be precalculated, before data is in powerbi.

    I need to create a visual table with 3 columns: nb of items per products (= max of nb of items per products in both table), number of product code from table1 and number of product code from table2. 

    I managed to do it, using calculated tables (summarized and groupby, cf. step1 and step2).

    I would like now to have the same calculation, but dynamic regarding filters users can define (on brand, product type, or, for table1, item category). I think this requires to have step1 and 2 done with a measure or a calculated column, but I'm stuck !

    Thank you for your help