Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Date | ID_Customer | Fee |
201801 | 521223 | 6 |
201802 | 521223 | 6 |
201802 | 521223 | 14 |
201802 | 521223 | 5 |
201802 | 521223 | 7 |
201802 | 521223 | 18 |
201803 | 521223 | 4 |
201803 | 521223 | 16 |
201803 | 521223 | 2 |
201801 | 1026532 | 20 |
201801 | 1026532 | 6 |
201801 | 1026532 | 16 |
201802 | 1026532 | 18 |
201802 | 1026532 | 18 |
201802 | 1026532 | 12 |
201802 | 1026532 | 8 |
201803 | 1026532 | 17 |
201803 | 1026532 | 19 |
Solved! Go to Solution.
Hi @Guille2711410 ,
Sum of Max Fee by Date and ID =
SUMX (
SUMMARIZE ( 'Table', 'Table'[ID_Customer], 'Table'[Date] ),
CALCULATE ( MAX ( 'Table'[Fee] ) )
)
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
Proud to be a Super User!
Hi @Guille2711410 ,
Sum of Max Fee by Date and ID =
SUMX (
SUMMARIZE ( 'Table', 'Table'[ID_Customer], 'Table'[Date] ),
CALCULATE ( MAX ( 'Table'[Fee] ) )
)
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
Proud to be a Super User!
Thank you very much Nathaniel, I'm so hapy.
You don't know how to serve me.
Thank you very much again
Hi @Guille2711410 , you are welcome!
Nathaniel
Proud to be a Super User!
Hi @Guille2711410 ,
In the first case, we have Date = 201801, ID_Customer = 51223. There is no customer with that ID. Can you post a pbix? And what your expected outcome is?
Please read this post to get your question answered more quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Nathaniel
Proud to be a Super User!
Ohh, your absolutily right, the ID_Customer is 521223.
I'm new, I don't understand how to post PBIX.
I hope to get the sum of all the maximums according to the criteria described.
Thank you very much.
Hi Nathaniel_C
I would very much apreciate helping you with this consultation, it's very urgent.
I can be a great promoter of Power BI in the company where I work.
Thank you very much.
User | Count |
---|---|
40 | |
26 | |
22 | |
16 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
17 | |
15 |