Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I would like to show daily actual sales figure with a total for the period.
But for Target i want only the Target for the period.
The Period depends on a Date slicer.
Does anyone have any idea how can i do this ?
Or if its not possible for PowerBI ?
Thanks for the assistance.
Hi @Anonymous
Please share your data and the required/expected results.
Also, is target a calculated column?
Cheers!
Hi,
Target is a measure.
based on 'Workdays' for the period x "Target Hours per day for the category"
thanks for the response
@Anonymous ,
Generally, you need an aggregation value based on selected period and category, right? If it is, you may create a measure using DAX like below and drag the measure to the value field of the matrix:
Result = CALCULATE ( SUM ( Table[Sales] ), ALLSELECTED ( Table ) )
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Thanks for helping out.
i am not sure if i done it wrongly but the result is not what i am looking for.
Hi all,
can someone please assist me in this area ?
or what i'm asking is not possible to do in Matrix table ?
Thanks alot
User | Count |
---|---|
103 | |
87 | |
77 | |
70 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |