Forum Discussion
Use multiple cards with multiple filters
Good community. I have the following query, on the same sheet I need to have two cards, where each one has a different date filter. Example amount of inputs that entered from 1 to 7 and amount of inp...
Hi Syndicate_Admin ,
What does the 1-7 stand for? The date day of [date of entry] and [date of discharge], ike 2021/10/1 -2021/10/7?
And did you create parameter for display 1-7?
Count of entry = CALCULATE(COUNTROWS('Date'), FILTER('Date', DAY('Date'[date of entry])>=MIN('Parameter'[Parameter]) && DAY('Date'[date of entry])<=MAX('Parameter'[Parameter])))Count of discharge = CALCULATE(COUNTROWS('Date'), FILTER('Date', DAY('Date'[date of discharge])>=MIN('Parameter'[Parameter]) && DAY('Date'[date of discharge])<=MAX('Parameter'[Parameter])))
If it isn't your expected, please share more detail information to help us clarify your scenario,refer to:
How to provide sample data in the Power BI Forum - Microsoft Power BI Community
How to Get Your Question Answered Quickly - Microsoft Power BI Community
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.