Forum Discussion
Solved
User Input in Power BI
Hello Everyone, I’m working on creating a Power BI report where users can input a specific date to drive the metrics displayed in the report. I’m exploring options to achieve this and need some g...
Based on your needs, I have created the following table.
Then you can use the following measure to calculate the result you want:
Number of Issues Logged = COUNTROWS('Table')Number of Issues Completed = CALCULATE(COUNTROWS('Table'),FILTER('Table','Table'[Status] = "Completed"))Number of Open Issues = CALCULATE(COUNTROWS('Table'),FILTER('Table','Table'[Status] = "In-Progress"||'Table'[Status] = "Not started"))Number of Issues Logged in the Last Two Days = CALCULATE(COUNTROWS('Table'),DATESINPERIOD('Table'[Logged date],SELECTEDVALUE('Table'[Logged date]),-2,DAY))Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Based on your needs, I have created the following table.
Then you can use the following measure to calculate the result you want:
Number of Issues Logged = COUNTROWS('Table')
Number of Issues Completed = CALCULATE(COUNTROWS('Table'),FILTER('Table','Table'[Status] = "Completed"))
Number of Open Issues = CALCULATE(COUNTROWS('Table'),FILTER('Table','Table'[Status] = "In-Progress"||'Table'[Status] = "Not started"))
Number of Issues Logged in the Last Two Days = CALCULATE(COUNTROWS('Table'),DATESINPERIOD('Table'[Logged date],SELECTEDVALUE('Table'[Logged date]),-2,DAY))
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.