User Profile
rammishra
Helper II
Joined 7 years ago
User Widgets
Contributions
Re: Dynamic distinct counts by group by considering only latest records
Hi, Please refer to the solution provided by Amit in the thread. The calculation of Measures should provide you the solution. If you are stuck, please share more details to understand it better. An alternate solution could also be achieved by using calculated columns (define a boolean column to check whether the record is 'latest' based on your criteria and then use this column to visualize only latest values on the chart).2.1KViews0likes1CommentDynamic distinct counts by group by considering only latest records
Hello friends I am stuck with a problem that looked simple but I am not able to fix it. I seek support from you. I have a table (named FACT) that contains data coming from monitoring visits to health facilities. The key columns in this table are: FacilityID- a text column taken from the database Date of visit - Date column taken from the database Score- a calculated column based on the observations recorded during the visit Rank category- a calculated column based on the scores. It has values like "Low", "Medium", "High" based on the score column and predefined cutoff values of the scores. I want to create a pie chart that shows the distribution of facilities across ranks based on the most recent visit to the facility. The pie chart should be updated dynamically when I use the date of visit as a slicer. For instance, consider a facility "A" which had a rank of "Low" based on the first visit conducted on 1st Jan. The same facility was visited on 10th Jan and ranked "Medium". If I select the date range, from 1st Jan to 10th Jan, then this facility should only be counted once with rank "Medium" in the pie chart (as that is the latest observation). If I select the date range from 1st Jan to 9 Jan, then this facility should be counted with rank "Low" (as that is the most recent observation for this facility in the date range specified). I could identify the latest records using calculated columns and used visual level filter but this did not work as calculated columns do not update their values based on slicers. Thanks in advance for your help.Solved2.4KViews0likes6CommentsGráfico de burbujas en un mapa
Estimados miembros de la Comunidad. ¿Es posible crear un gráfico de burbujas en la parte superior de un mapa (mapa de calor o mapa rellenado) en Power BI. Tengo dos indicadores (distrito sabio). Quiero usar un indicador para crear un mapa de calor y un segundo indicador para trazar burbujas en cada distrito. Un gráfico similar creado con otra herramienta (DevInfo) se puede ver aquí (como mapa de ejemplo que quiero crear en Power BI): https://we.tl/t-aWpJBQ7TvZ Gracias y saludos Ram783Views0likes3Comments
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.