User Profile

geoffgarcia

Helper I

Joined 6 years ago

17 Posts2 LikesLikes received

View All Badges

User Widgets

Contributions

Counting the results of a measure
Our sales team have lots of sales plans. To identify open plans I created a measure to evalute for a null or future end date. I then want to list out each sales team member and a count of their open plans. However, when I add the measure to the table visual a "count" is not an option. Where have I gone wrong and how can I produce a count? Measure: Open Assignment = var date1=SELECTEDVALUE(v_account_HT_solicitor[ASSIGNMENT END DATE]) Return If(ISBLANK(date1) || date1>TODAY(), 1,0) Plan Table Sales Person Plan ID Plan End Date Jane 1 Jane 2 5/1/2024 Bob 3 Sales Person Table Sales Person Jane Bob
Solved
2 years ago Place DAX Commands and Tips
521Views
0likes
2Comments
Re: Count rows in another table that match the current row
Thanks Chris - that is so simple! I'm still a little lost on a measure versus a column, but will take a look. TY!
5 years ago Place Desktop
9.8KViews
0likes
1Comment
Re: Count rows in another table that match the current row
The rule of Geoff is within 5 minutes of asking a question I figure it out on my own. I believe the answer is: EmployeeCount = var _CurrentRowValue = Office[Office_ID] RETURN COUNTROWS( Filter(Employees, _CurrentRowValue=Employees[Employee_ID] ))
5 years ago Place Desktop
9.8KViews
1like
0Comments
Count rows in another table that match the current row
I've spend a healthy amount of time looking for a solution and am posting here as a last hope. I have a table of offices and a table of employees, and very simply need to find a count of all employees in an office. I'd like to add the employee count as a calculated column to my Offices table. I've tried a number of things but nothing has gotten me the results I expect (red font below). Any suggestions? Table: Offices Office_ID Employee_Count (calculated column) NY656 3 NJ999 1 CT001 1 Table: Employees Employee_ID Office_ID 1001 NY656 1002 NY656 1003 NY656 1004 NJ999 1005 CT001
Solved
5 years ago Place Desktop
Need Help
9.8KViews
0likes
4Comments
Re: Common Data Source
Thanks - yes, that is exactly what I'm doing and appreciate the feedback.
5 years ago Place Desktop
1.2KViews
0likes
0Comments
Common Data Source
I use a common data source of HR information for the majority of my reports. The data source is based on Excel files which I need to routinely pull and refresh. My approach has been to use a common folder for these files, rather than copy them for each project I create. Is there a more efficient way to do this? There is still a level of manipulation that I need to do for new data, and I was thinking perhaps there was a better approach. Any thoughts? Thanks, Geoff
Solved
5 years ago Place Desktop
Need Help
1.2KViews
0likes
2Comments
Scoring text
I have a column of types of fruit and want to add a score for each (Apple = 1, Banana = 2, Cherry = 3, etc.). I've tried to create a measure thinking I could use an IF condition, but my text based fruit field doesn't return as an option. My thought was something simple like: If(table[fruit]="Apple") then 1 Else If(table[fruit]="Banana") then 2 Else If(table[fruit]="Cherry") then 3 How can I do something like this? Thanks, Geoff
Solved
6 years ago Place Desktop
Need Help
802Views
0likes
2Comments
Re: Vizualizar las respuestas de los proveedores a los requisitos para un proceso de selección
Gracias Ken, he planteado todos tus consejos y funciona como esperaba. Muchas gracias por una respuesta tan rápida y clara.
6 years ago Place Translated Spanish Desktop
535Views
0likes
1Comment
Re: Vizualizing vendor responses to requirements for a selection process
Thanks Ken, I follwed all of your advice and it works as I had hoped. Thank you so much for such a fast and clear response.
6 years ago Place Desktop
1.1KViews
0likes
1Comment
Vizualizar las respuestas de los proveedores a los requisitos para un proceso de selección
Soy nuevo en Power BI, así que discúlpate por una pregunta tan simple. Estamos realizando una evaluación de proveedor y mi conjunto de datos incluye el IDENTIFICADOR, la pregunta y la respuesta de cada proveedor (captura de pantalla a continuación). Me gustaría poder visualizar los recuentos de cada respuesta (fuera de la caja, personalizable, no posible, etc.) por proveedor, pero no puedo averiguar cómo llegar allí. He creado una medida que me permite contar el número de OOTB para el proveedor A, pero hacer esto para todas las respuestas y proveedores no parece la solución correcta. He intentado colocar las respuestas en otra tabla y vincularlas para hacer un recuento, pero no estoy seguro de cómo vincular la tabla a las varias columnas de mi tabla de respuestas. Cualquier orientación sería muy apreciada. Gracias Geoff Datos Datos Visualización deseada (algo así) Gol
6 years ago Place Translated Spanish Desktop
566Views
0likes
3Comments

Data Privacy

Microsoft Fabric Community and Privacy

To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.