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,
I have a matrix report where I have created a measure for values "Reveue-Expenses", it is working fine for all the columns except the last column, please find the below image for reference
The Total at the right and bottom pops out wrong values it should be 30,059 insted of 52,180.
Pleasse help.
Thanks in Advance.
Hi @neelofarshama ,
You may create a new measure like DAX below.
Measure_New=
var _table = SUMMARIZE(Append1, Append1[Acct Type],"_Value", [Forecast] )
return
IF(HASONEVALUE(Append1[Acct Type]), [Forecast], SUMX(_table,[_Value]))
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@neelofarshama , can you share the formula you are using.
Refer if this can help: https://www.youtube.com/watch?v=ufHOOLdi_jk
Hi,
I have shared my formula could you please suggest where did i go wrong, itwill help me a lot
Try:
Forecsat = SUMX(Append1, SUM(Append1(Actual) + SUM(Append1(Forecast Remaing))
Proud to be a Super User!
Paul on Linkedin.
Hey Thank you so much for the reply but It did not work it is giving me wrong values, I have used the formula you suggested and created measure "New Forecast"
Without seeing how the model is set up and the tables used it is a bit of a guessing game, However, let's try the following. Assuming your period column is from a Period Table[period], try:
New forecast = SUMX(Period Table, SUM(Append1(Actual) + SUM(Append1(Forecast Remaing))
If that doesn't work, can you show the hierarchy in the matrix, the model and relationships within?
Proud to be a Super User!
Paul on Linkedin.
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 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |