Skip to main content
Showing results for 
Search instead 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

Post Patron
Post Patron

Calculate based on dates


I have a problem that i need little help with , it needs to be in a measure

I have a table with Fruits , Store and Date ( the Measure is what i am looking for)
i want the a measure to calculate all dates that is Unique and greater then 1
We can see that greeen has 3 date for store A and that should give 2
Orange has one date and that should give 0 (want it to be blank)


Also if its possible i would like the measure (think it called dynamic) 

so if i have this table below in a column chart , date as X-axis and Y-axis count of fruit i would like the chart to show all the dates for fruit it i press the measure that has sum of 4  (Store A,B,E should be shown and 7 dates)


/Thanks so much for any help.


Super User
Super User

Screen Capture #657.pngScreen Capture #658.png

Hi @Ahmedx 
Thanks so much for this it calculate as i want 🙂

is it possible to make this measure (Calculate based on dates) work so when i press on it the table changes based on the values instead of needed to mark the 3 colums


did not understand what you need! you can show what you want?

Is it possbile to get the chart to react as picture below if i only press the measure "Calculate based on dates"
If i press the measure now it does nothing to the chart.

i can only get this resualt if i  ctl & press Store A , B and E 




Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.