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 ,

 

Sorry currently , I could only do this:

Please follow these steps:

countRows table1 = COUNTROWS('Tableau1')
count1 = 
VAR _T = SUMMARIZE(ALLSELECTED('Tableau1'),'Tableau1'[Product Code],"NEW",[countRows table1])
VAR _A = [countRows table1]
Return
COUNTAX(FILTER(_T,[NEW] = _A),[NEW])

countRows table2 = COUNTROWS('Tableau2')
count2 = 
VAR _T = SUMMARIZE(ALLSELECTED('Tableau2'),'Tableau2'[Product Code],"NEW",[countRows table2])
VAR _A = [countRows table2]
Return
COUNTAX(FILTER(_T,[NEW] = _A),[NEW])

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,

    The result is not what I expected. 

    But thanks for having a look at it - your answer brought some new ideas to me.

    Best regards,

    Anne-Sophie