Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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)) )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |