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.
I wonder if anyone can help me with thisproblem. Basically I have a list with 4 columns, in the first I have names, in the second are some of the names that are in the second (some of them may be blank, in the third is the month of creation and the last is the month resolved.
What I want to achieve is a summary of the first table:
In the column
Resolved I used the number of accounts (table1)resolved by the number (table2)resolved by AND (table1)resolved month 12
Reiterates that I used the month of accounts (table1) resolved by the previous month (table2) resolved by AND (table1)created month 12
I used the SUMMARIZE formula in powerbi*
I have this:
Any help is highly appreciated. Thanks a lot
Edit: I used this formulas in PowerBi
Solved = COUNTROWS(FILTER('Table1','Table1'[Solved by]='Table1'[Solved by] && 'Table1'[resolutiondate] >= MIN('Date'[Date]) && 'Table1'[resolutiondate] <= MAX('Date'[Date]))) Reiterate = COUNTROWS(FILTER('Table1', 'Table1'[Solved by previous]='Table1'[Solved by previous] && 'Table1'[createddate] >= MIN('Date'[Date]) && 'Table1'[createddate] <= MAX('Date'[Date])))
The problem that I have is with the second formula, when I put it on a matrix it classifies it only with respect to solved by and not solved by previous. Any help is really appreciated. Thanks a lot.
Solved! Go to Solution.
Hi @alfonsoasenjo ,
Please create measures like below and then create a calculated table.
Measure = CALCULATE(COUNT('Table'[Sloved by previous]),FILTER(ALL('Table'),'Table'[Created Month]=12&&'Table'[Sloved by previous] in VALUES('Table'[Sloved by])))+0
Measure 2 = CALCULATE(COUNTROWS(FILTER('Table','Table'[Resolved Month]=12)))+0
Table 2 = SUMMARIZE('Table','Table'[Sloved by],"S",[Measure 2],"Re",[Measure])
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @alfonsoasenjo ,
Please create measures like below and then create a calculated table.
Measure = CALCULATE(COUNT('Table'[Sloved by previous]),FILTER(ALL('Table'),'Table'[Created Month]=12&&'Table'[Sloved by previous] in VALUES('Table'[Sloved by])))+0
Measure 2 = CALCULATE(COUNTROWS(FILTER('Table','Table'[Resolved Month]=12)))+0
Table 2 = SUMMARIZE('Table','Table'[Sloved by],"S",[Measure 2],"Re",[Measure])
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |