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.
Solved! Go to Solution.
Hi @SkorpionAAM ,
If you want to get the maximum [Expected] of each 'mms Statistics (2)'[run_name_segement]) and 'mms Statistics (2)'[layername] ? If so , please try:
MAXX = MAXX(FILTER(ALL('mms Statistics (2)'),[run_name_segement] =MAX('mms Statistics (2)'[run_name_segement]) && [layername] =MAX('mms Statistics (2)'[layername])),[Expected])
Hi @SkorpionAAM
Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or if you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.
Best Regards,
Eyelyn Qin
Hi @SkorpionAAM ,
If you want to get the maximum [Expected] of each 'mms Statistics (2)'[run_name_segement]) and 'mms Statistics (2)'[layername] ? If so , please try:
MAXX = MAXX(FILTER(ALL('mms Statistics (2)'),[run_name_segement] =MAX('mms Statistics (2)'[run_name_segement]) && [layername] =MAX('mms Statistics (2)'[layername])),[Expected])
You can share the PBIX from Google Drive for example.
Also check out this thread to see if it helps:
https://community.powerbi.com/t5/Desktop/MAX-date-by-group/m-p/2342732#M845015
Proud to be a Super User!
Paul on Linkedin.
any luck ???
Sorry but which unique value do you wish to calculate and what visual are you placing it in? Please provide a depiction of the visual
At a guess:
Proud to be a Super User!
Paul on Linkedin.
i tred this but no success
Please find the Gdrive link
https://drive.google.com/file/d/1pEsmgX5xflmXAvbkqeyrz1Y84BYcyjtL/view?usp=sharing
Please provide sample data and a depiction of the expected output to help us understand what you need and provide a working solution.
Proud to be a Super User!
Paul on Linkedin.
I want Unique value of latest Date group by Layname,Run Name Segmenr and Latest Date ..
I can share the Power Bi File If you want please let me can i share the file on Google Drive>>
How can i share Sample data Or Power BI file
aNYONE Please
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 |
---|---|
113 | |
104 | |
77 | |
67 | |
63 |
User | Count |
---|---|
144 | |
107 | |
105 | |
82 | |
69 |