Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hi,
I need to create a table which will show data based on month filter selected and also based on another flag.
so
so say in the snipping i have June month selected, so the table below should show data for all Flag=Yes and Month = April may and june
But for Rows with Flag= No, it should show only rows with month = June and not show other months in table.
Is this doable?
Result
I am not sure how to attache the dashboard here, otherwise i would have done it
Thanks in advance
Regards,
Rolin
Solved! Go to Solution.
@RolinMartis , In this case, the date slicer needs to be on an independent date table
then you can measure like
//Date1 is independent Date table
new measure =
var _max = maxx(allselected(Date1),Date1[Date])
var _min = minx(allselected(Date1),Date1[Date])
return if(selectedvalue(flag[flag) = "Yes" ,
calculate( sum(Table[Value]), filter('Table', 'Table'[Date] >=_min && 'Table'[Date] <=_max)),
calculate( sum(Table[Value]), filter('Table','Table'[Date] <=_max)) )
Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI
@RolinMartis , In this case, the date slicer needs to be on an independent date table
then you can measure like
//Date1 is independent Date table
new measure =
var _max = maxx(allselected(Date1),Date1[Date])
var _min = minx(allselected(Date1),Date1[Date])
return if(selectedvalue(flag[flag) = "Yes" ,
calculate( sum(Table[Value]), filter('Table', 'Table'[Date] >=_min && 'Table'[Date] <=_max)),
calculate( sum(Table[Value]), filter('Table','Table'[Date] <=_max)) )
Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI
HI @amitchandak
One last question.
what should i do if i need to show number of rows in a card instead of table. I added the same measure in card but it gives me less count.
below is my formulae
HI @ Amit,
Thanks alot for your solution. It worked for me.
Just had to change the formulae a bit in else condition instead of <= I had to use = as below and everything worked fine
calculate( sum(Table[Value]), filter('Table','Table'[Date] =_max)) )
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.