Dimension columns with all values

[Peter_23]

Hi Power bi users 🙂 , I'm trying to figure out a calculated dimension (Stores) with values: currently and past values, and slicer to change the months. When I select Jan-Feb24 in slicer I compared this period with Jun-Jul23 this fine, but the C store in the currently period doesn't have value so it's missing in table 😞 . But the total is correct.

How to it's possible to  show the all values in dimension (store)?

I attach pbix file 

Thanks in advance.

[Anonymous]

Hi, @Peter_23 

Have you solved your problem yet? I failed to open your link. If your problem has not been solved, please provide more information about the source data.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Peter_23]

I share the Link 

[Anonymous]

Hi, @Peter_23 

You can try the following methods. Create a new table.

Currently = CALCULATE(SUM(Hoja1[Sales]),FILTER(ALLSELECTED(Hoja1[Time],Hoja1[Stores]),[Stores]=SELECTEDVALUE(Stores[Stores])))

Previous = CALCULATE([Currently],FILTER(ALL(Hoja1),[Year Order]=SELECTEDVALUE(Hoja1[Year Order])-1))

Is this the result you expected?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Peter_23]

@Anonymous  thanks amazing!  is there way to include total?

[Anonymous · Accepted solution]

Hi, @Peter_23 

You can try the following methods.

Measure 1 = 
Var _table=SUMMARIZE(Stores,Stores[Stores],"Sum sales",[Currently])
RETURN
SUMX(_table,[Sum sales])

Measure 2 = 
Var _table=SUMMARIZE(Stores,Stores[Stores],"Sum previous",[Previous])
RETURN
SUMX(_table,[Sum previous])

Is this the result you expected?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Select "Show items with no data"  for the Stores column.

[Peter_23]

I select this option, but it doesn't work 😞

[lbendlin]

Your time filter interfered.

You need to invest in a calendar table and/or in a disconnected table for the slicer.

[Peter_23]

@lbendlin  I knew, this is another path to follow,  time disconnected table 🤔