Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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 , 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)))
@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>))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
19 |