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 everybody,
I am aware that there are hundreds of posts on the topic "total of measure is incorrect" and I have read most of them. Yet, I cannot solve a rather simple issue:
Equipment Name | Days | Daily Rent | Rent x Days (var ) | Rent x Days (isfiltered) | Rent x Days (Hasonefilter) |
Equipment 1 | 5 | 0.52 | 2.58 | 2.58 | 2.58 |
Equipment 2 | 5 | 6.45 | 32.26 | 32.26 | 32.26 |
Equipment 3 | 5 | 3.23 | 16.13 | 16.13 | 16.13 |
TOTAL | 6.45 | 12.90 | 12.90 |
Rent x Days (Hasonefilter) =
Rent x Days (var) =
Rent x Days (Isfiltered) =
Solved! Go to Solution.
What I mean was the calculation is done on eth measures which are not visible in the example. (It became -- the same)
I think I still need more information to help. But if the problem is that you are doing an operation which has two levels of operations. Sum till one place and product post that values can help
Try
if(
HASONEFILTER(time_entries[Equipment Name (from Gsheet)]),
[Dias Operativos Measure] * [Arriendo diario],
sumx(values(time_entries[Equipment]),
[Dias Operativos Measure] * [Arriendo diario]))
sumx(values(time_entries[Equipment]),
[Dias Operativos Measure] * [Arriendo diario])
You may check if [Equipment Name (from Gsheet)] is renamed to [Equipment Name] in the Visualizations pane and use ISINSCOPE instead if necessary.
You seem to be using measures that are not visible in the same. I tried a simple formula and it worked. To help you further I need pbix file. If possible please share a sample pbix file after removing sensitive information.
ProductSum = sumx(time_entries,time_entries[NameDays]*time_entries[Daily])
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
Thank you very much for your super-quick response @amitchandak !
I am not sure I understand what you mean by "using measures that are not visible in the same".
I think your solution is working, because "Name Days" and "Daily" are columns. In my case they are measures whose home table is "time_entries". Sorry that I was not clear enough in the first place.
"Days" is a measure that counts days of a filtered period (e.g. 01.01.2019 to 05.01.2019 = 4 days)
"Daily Rent" is a measure that uses a column value (=Monthly Rent) and divides it by the number of days the month in the filter has (in the example above: 31 days in January).
Unfortunately, I cannot share the PBI file as it is connected to a clients database. I hope you can still help me out.
What I mean was the calculation is done on eth measures which are not visible in the example. (It became -- the same)
I think I still need more information to help. But if the problem is that you are doing an operation which has two levels of operations. Sum till one place and product post that values can help
Try
if(
HASONEFILTER(time_entries[Equipment Name (from Gsheet)]),
[Dias Operativos Measure] * [Arriendo diario],
sumx(values(time_entries[Equipment]),
[Dias Operativos Measure] * [Arriendo diario]))
sumx(values(time_entries[Equipment]),
[Dias Operativos Measure] * [Arriendo diario])
@amitchandak , fantastic! Adding the VALUES to the SUMX formula did the trick. I cannot really explain why at the moment, but it works which is what counts. I will chew on the why and how later. Thanks a lot for your help!
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 |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |