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, guys!
Please, need your help
When I choose date by the month in the filter filed it shows "correct" unit cost. But when I want accumulate data for several months it just summarize unit cost. For example, I want to see unit cost for 3 months ( 1 quarter) instead of showing unit cost for 3 months (Sum of costs for 3 months/ Production of item for 3 months) it return the sum of unit cost (as it shown below in the graph). What dax formula should I use to make it correct? Thanks
"Сумма" = SUM
"Производство" =Production
"УдСебГаз" = Unit cost (SUM/Production)
@DauletKali , Not very clear. Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Typically unit cost is
Measure unit cost divide(Sum(Table[Value]),sum(Table[Qty]))
"Measure unit cost divide(Sum(Table[Value]),sum(Table[Qty]))"
This measure does not work in this case
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 |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
147 | |
109 | |
107 | |
85 | |
63 |