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 Experts,
@Greg_Deckler
I have tried using summarize, sumx and hasonevalue function still giving incorrect result in total. I have used 3 different measure which I have written below
Measure 2
Measure 3
Final=
Var A= 300000/Last day of the month
Var B= A*( Datediff)
Var C =A*B
Var D= C*(%sum)
return D
I want to show Final measure in matrix visual agianst month, week and category dimension. Row wise data is showing correctly but at total showing incorrect data.
I
I want answer to be 2032819+544684=2577503 for D
Any help would be appreciated.
Thank you in advance.
Solved! Go to Solution.
@Uzi2019 , Try to use something like below:
@Uzi2019 , Try to use something like below:
I got my total corretly. thank you so much.
@Uzi2019 So, based on 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, you are really going to need something like MM3TR&R. Matrix Measure Total Triple Threat Rock & Roll - Microsoft Power BI Community
Assuming that you have a measure that is working at the month and week levels, I imagine it would be something like:
Measure Total =
VAR __CurrentCount = COUNTROWS('Table')
VAR __AllCount = COUNTROWS(ALLSELECTED('Table'))
VAR __Total = SUMX('Table',[Month],"__Measure",[This is your existing measure])
RETURN
IF(__CurrentCount = __AllCount,__Total,[This is your existing measure])
Hey @Uzi2019 ,
what exactly should the result be?
Can you provide a sample file? It's a little difficult to help you with that small amount of information.
Best regards
Denis
Hi @selimovd ,
I want answer to be 2032819+544684=2577503 for final measure
@Uzi2019 Can you share the file or create a sample file if the content is confidential?
Hi @selimovd
sorry but cant share the file it has confidential data.
can u help me by looking at this image? or suggest some measure which gives correct total.
@Uzi2019 it looks like it could be semi additive values, but you have to share more information.
If the data is confidential, then please create a similar file with fake data and the same behavior. But if you just say "look, it's wrong" and don't provide more information I don't know what to tell you.
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 |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |