Matrix table to show value on Column and period

[Anonymous]

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.

[Anonymous]

Hi @Anonymous 

Please share your data and the required/expected results.

Also, is target a calculated column?

Cheers!

[Anonymous]

Hi,

Target is a measure.

based on 'Workdays' for the period x "Target Hours per day for the category"

thanks for the response

[v-yuta-msft]

@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.

[Anonymous]

Hi,

Thanks for helping out.

i am not sure if i done it wrongly but the result is not what i am looking for.

[Anonymous]

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