I need to calculate penetration rate in 2-wheeler and 4-wheeler EV sales. How can I calcite it?

I have a PowerBI dashboard that I’m building which needs to limit the data in the SQL query due to the quantity of data that exists in the tables/views of origin. Additionally, as the WHERE statement is quite complex, I don’t believe the parameterization/filtering can be handled by PowerBI after the data has been brought in. I’ve created two parameters in PowerBI called “Start Date” and “End Date” and updated the source SQL statement to pull from a view. When I hardcode the dates (example ‘2024-07-01’ and ‘2024-07-24’ as start date and end date respectively), the SQL statement pulls the correct data: ~43,000 rows. When I substitute the parameters for the hardcoded dates, it doesn’t return any rows of data. Here’s the code with the parameters:

We’re using Laravel as API that provides the JSON data for Power BI application. The problem I have right now is that the Power BI checks the URL, then connects to the URL and only then it pulls the data. But my API is not aware of those two initial “connection attempts” and it compiles and returns entire data set.

I’d like to use a bullet chart in Power BI, but the data I have is time-based and the system doesn’t recognize and display this data type. I don’t want to convert my time data to a numerical format and I want to keep it in its original time format. Please advise on how to achieve this.

I need you assistance on this measure that I am working.
I want to make a dynamic Supervisor Score card. Where on PowerBI Visual I have a month Slicer, to show the score of each team leader, the score is being calculated by determining if employee has a score of 4 or 5, it means they passed. if 3 or below, the employee failed. it the supervisor has 10 employees and 6 of them got a 4 above score, the supervisor’s score should be 60%. the reason why it should be dynamic is because, if the employee is terminated on march 15, 2024, when you select January or February on the month slicer, the employees should still be counted on the supervisor’s score, but, if march is selected, this employee should be remove from the supervisor’s score

Here is the image of the query and the error with it
[The syntax for ‘)’ is incorrect. (DAX(VAR dateValue = VALUE(‘Measurement'[Latestdate]) VAR measureQues = CALCULATE( COUNTROWS(Measurement), ALLEXCEPT(Measurement, Measurement[Questions], Measurement[Employee ID], Measurement[ContainsResponse]), Measurement[Date] = dateValue ))).]

I have measures measure1 = Sum(column name). Then I am dividing Divide(measure1, measure2). I am trying to display only values those are greater than 0. Why do table total changes after removing 0.

I’ve been following a tutorial on PowerBI, and there is a line chart in the dashboard that is supposed to look like this…