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.
i have the table . values showing like year wise 2021 data value 32 only .
please find the below screen shot refernce .
when i change it to Sum .its values showing .
i am using below measure for the calculate the value.
Hi @THENNA_41 ,
According to your description, warehouse infeasibility (tons) is a measure, but how can it have three values when it is alone in a visual, additionally, is [WarehouseInfeasibility] a measure or column? Could you please provide more sample data, it will help find the problem.
If you want to show correct total in summarize, you can calculate the sum based on old measure, like this:
SUMX(table,[ warehouse infeasibility (tons) ])
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
This problem is likely causes by the logic behind calculated column. To solve the issue check if your slicers are working. Additionally I would recommend using use a SUM measure instead of summarizing a calculated column.
So something like (
My test data:
Problem reconstructed:
Without any selections the divide seemingly works:
When changed to summarize the value doubles:
(Slicer) While I select 2021 from a slicer the value works as intended:
Hopefully this helps to solve the issue and if it does consider accepting this as a solution!
Proud to be a Super User!
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |