The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
Hi everyone,
The following formula is working, except for the outcome it shows for Total:
I think I only need a small adjustment, but I couldn't figure out how to apply this. The result of Total should be 18.
Solved! Go to Solution.
@Anonymous - As I have been trying to point out, the solution is this Quick Measure, Measure Totals, The Final Word:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
The implementation in your situation is:
Greg_Deckler =
IF(
HASONEVALUE('Inspection 2016-2020'[Name]),
[Most recent values -1],
SUMX(
SUMMARIZE(
'Inspection 2016-2020',
[Name],
"Measure",[Most recent values -1]
),
[Measure]
)
)
PBIX is attached.
@Anonymous ,
Try like
XXX =
VAR MaxYear = YEAR(MAX('Table'[Date]))
VAR MaxMonth = MONTH(MAX('Table'[Date]))
RETURN
SUMX(summarize(FILTER('Table';[Year]=MaxYear&&MONTH([Date])=MaxMonth&&[Value]=-1);'Table'[Location];"_TEST";COUNT([Value])),[_TEST])
Hi @amitchandak ,
Thanks for you reply.
I received the exact same results with your formula, so Total still shows 1.
@Anonymous ,
Can you share sample data and sample output.
Sure, here is the Excel file:
https://drive.google.com/file/d/13HR8-JiYunuB0aFqfd1H3iUGRWjLYIE7/view?usp=sharing
And here is the PBI file:
https://drive.google.com/file/d/1-qDDE9Tccf7UurvCBZc-i0nlZe2C0Ovb/view?usp=sharing
@Anonymous , @Greg_Deckler has already provided the solution. So no need for me to check
@Anonymous - As I have been trying to point out, the solution is this Quick Measure, Measure Totals, The Final Word:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
The implementation in your situation is:
Greg_Deckler =
IF(
HASONEVALUE('Inspection 2016-2020'[Name]),
[Most recent values -1],
SUMX(
SUMMARIZE(
'Inspection 2016-2020',
[Name],
"Measure",[Most recent values -1]
),
[Measure]
)
)
PBIX is attached.
Sample data would really help. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
But still, This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
User | Count |
---|---|
158 | |
109 | |
96 | |
83 | |
75 |
User | Count |
---|---|
154 | |
137 | |
131 | |
81 | |
62 |