Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
84 | |
65 | |
62 | |
55 |
User | Count |
---|---|
179 | |
108 | |
104 | |
71 | |
70 |