cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper III

## Slicing Dates problem

Hi Everyone, I have a problem with my date slicers, here is my model:

I have computed for the Amount for both Order and AP table (With common PO#) , using this function

= Calculate( Amount ,
Treatas( Summarize ( Orders, Orders[PO #] ) , AP[PO #] ))  - It works as i intended,
However, whenenver i try to slice thru dates (month or year) it doesnt show anything.

I hope you can help me with this, any insight will surely be a great help!

Thank you!

1 ACCEPTED SOLUTION
Community Support

Hi, @jmcph

It’s my pleasure to answer for you.

According to your description,I think you can try ’allselected’ in your formula when you use a slicer.

Like this:

Calculate( Amount ,

Treatas( Summarize ( Allselected(Orders), Orders[PO #] ) , AP[PO #] ))

Best Regards

Janey Guo

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

2 REPLIES 2
Community Support

Hi, @jmcph

It’s my pleasure to answer for you.

According to your description,I think you can try ’allselected’ in your formula when you use a slicer.

Like this:

Calculate( Amount ,

Treatas( Summarize ( Allselected(Orders), Orders[PO #] ) , AP[PO #] ))

Best Regards

Janey Guo

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

Super User

@jmcph , dates you are taking from the calendar table?

Can you share  a sample pbix after removing sensitive data.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.