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.
Measure not giving the value proper:
I have used below measure to calculate the revenue based on year-month field.
Price = sum('table'[amount])
And it is giving me wrong result!!
Below screenshot shows what exactly i needMeasure not giving the value proper:
I have used below measure to calculate the revenue based on year-month field.
Price = sum('table'[amount])
And it is giving me wrong result!!
Here price is getting doubled sometimes dont know why?!!
Can anyone help me with this.
Solved! Go to Solution.
You must have other columns/filters to slice your measure. Otherwise your amount should aggregate on Year-Month fields. Even you select "do not aggregate". The amount must be separated based on other group column. You may change your measure into:
Price = CALCULATE ( SUM ( Table[Amount] ), ALLEXCEPT ( Table, Table[Year-Month], Table[Group] ) )
Regards,
You must have other columns/filters to slice your measure. Otherwise your amount should aggregate on Year-Month fields. Even you select "do not aggregate". The amount must be separated based on other group column. You may change your measure into:
Price = CALCULATE ( SUM ( Table[Amount] ), ALLEXCEPT ( Table, Table[Year-Month], Table[Group] ) )
Regards,
Assuming you have put 'Ar maned' and 'Amount' on the "rows" of the visual, then for example in your third row shown, your measure SUM('table'[amount]) will sum up all the values in 'table' where Ar maned = 201705 and Amount = 28.95. So you must have 2 rows in the table that match this criteria which is why you are getting the results doubled like you are. Some rows meet the criteria twice (or more. At bottom of visual i see some results 4x Amount).
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 |