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.
Hi Team,
I want the result of test growth to display 0.71 based on the highest month which is July but it ended up sum all of the value and ended up with result -1.0 for the total value.
Is there anyway to display only row value based on highest selected month that come with multiple selections as title mentioned.
Thank you.
Solved! Go to Solution.
Hi @Anonymous ,
Create a measure as below:
_Growth =
var _maxmonth=CALCULATE(MAX('Table'[Month]),ALLSELECTED('Table'))
Return
IF(ISINSCOPE('Table'[Month]),
SUM('Table'[Growth]),
CALCULATE(SUM('Table'[Growth]),FILTER(ALL('Table'),'Table'[Month]=_maxmonth)))
And you will see:
For the related .pbix file,pls see attached.
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Hi @Anonymous ,
Create a measure as below:
_Growth =
var _maxmonth=CALCULATE(MAX('Table'[Month]),ALLSELECTED('Table'))
Return
IF(ISINSCOPE('Table'[Month]),
SUM('Table'[Growth]),
CALCULATE(SUM('Table'[Growth]),FILTER(ALL('Table'),'Table'[Month]=_maxmonth)))
And you will see:
For the related .pbix file,pls see attached.
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Perhaps something like this, (btw its a DAX question):
Measure =
VAR _MaxMonth = calculate(max(month), allselected(months))
return
calculate(max(test growth)), filter(data, month = _MaxMonth))
Proud to be a Super User!
Awesome Keyboard Shortcusts in Power BI, thumbs up if you like the article
My Community Blog Articles (check them out!)
My Blog - Power M code to automatically detect column types -
How to create test data using DAX!
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 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
19 |