[Error] Couldn't load the data for this visual in DirectQuery mode
Hello, we are currently encountering an issue regarding data in the "Direct Query" mode: Within the Slicer: If it's single selection, the visualization chart encounters the following error: [OLE DB or ODBC error: [Expression.Error] Unable to fold the expression to the data source, please try a simpler expression] (as shown in picture below). If it's multi-selection, the visualization chart displays correctly. May I ask what could be the cause of this issue?
Measure is text only, won't recognize comma in formatting with DAX
someone said when I use FORMAT(), my ability to change the data type goes away and now this measure is text only. I tried removing the FORMAT() function and I still am only able to choose text as the type. See below : the formatting is fine except there are no commas. I am not able to change the data type and I am not able to use DAX to format commas. Does anyone have a solution ? thank you in advance 🙂Creating a measure to Count as 1 when everyday user Check In Twice in Applicaiton
Hello! I am trying to create a report for Temperature Check in daily for my organization use. A staff need to check in the application twice a day, which is morning and evening. Can we create a measure that count as 1 when a user check in twice a day ? Example: Check In Morning Check In Evening Count as 1 Yes Yes 1 Yes No 0
