count rows based on a measure

[Anonymous]

can anybody help me to solve my problem? I want to calculate orders that happend every 1-10 days in dax,(if end user dont select any product it should be calculated based on any transaction else based on product selected (if two product selected its not important which one is bought)) i wrote a measure that calculated datediff of every transaction per customer but i dont know how to countrows of a table based on a measure?

Customer	Product	Date
A	1	2020/01/01
B	1	2020/01/01
A	2	2020/01/09
B	1	2020/01/12
B	2	2020/01/13
A	1	2020/01/14

for example if end user dont select any product answer is 5 transaction (3 for A + 2 for B), if product 1 is selected, then answer is 0

[amitchandak]

@Anonymous , Try like

countx(summarize(Table,Table[product],"_1",distinctcount(Table[product]),"_2",calculate(distinctcount(Table[product])all(Table[product])),"_3", countrows(Table),
"_4",[Measure]),if([_2]=[_3],[_3],calculate([_3],[_4]>0)))

[Greg_Deckler · Accepted solution]

@Anonymous This looks like a measure aggregation problem. See my blog article about that here: https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149

The pattern is:
MinScoreMeasure = MINX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
MaxScoreMeasure = MAXX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
AvgScoreMeasure = AVERAGEX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
etc.

So, in your case perhaps you could use something like:

Measure =

  VAR __Table = ADDCOLUMNS('Table',"Measure",[Measure])

RETURN

  COUNTROWS(FILTER(__Table,<some filter>))

[Anonymous]

That works for me, Thanks