User Profile
FBergamaschi
Super User
Joined 1 year ago
User Widgets
Contributions
Re: Erro em Calculate com múltiplas referências de filtros
Hi, nothing has changed in the engine but the two codes you show are not identical. Please note that a filter on a column is one thing, while using an entire table reference as a filter is completely another thing (see expanded tables, here https://community.fabric.microsoft.com/t5/Desktop/How-expanded-tables-work/m-p/325210 So the first point is what behaviour are you looking for? I believe it might be your data changed in a way to make the behavior show up while before you did not notice the difference To understand better I should see the model Best If this helped, please consider giving kudos and mark as a solution me in replies or I'll lose your thread Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page Consider voting this Power BI idea Francesco Bergamaschi MBA, M.Eng, M.Econ, Professor of BI116Views0likes0CommentsRe: A Circular Dependency was detected
Hi Adavin are you sure this is a measure and not a calculated column? In order to help you, I need the pbix file, otherwsie it is impossible. Can you upload it on a shared floder and send em the link here or via private message? If this helped, please consider giving kudos and mark as a solution @me in replies or I'll lose your thread Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page Consider voting this Power BI idea Francesco Bergamaschi MBA, M.Eng, M.Econ, Professor of BI180Views0likes0CommentsRe: Calculate new column based on another column's text
Hi seankeatingpb , create a calculated column with this code (let's call it Hours and let's suppose your table in named CategoryMinutes) IF ( CategoryMinutes[Category] = "A", DIVIDE( CategoryMinutes[Minutes], 60 ) ) This will automatically leave a blank when category is different than A If this helped, please consider giving kudos and mark as a solution @me in replies or I'll lose your thread Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page Consider voting this Power BI idea Francesco Bergamaschi MBA, M.Eng, M.Econ, Professor of BI111Views1like0CommentsRe: how to combine 2 columns from different data sets in 1 new dimension
Hi Emmy88_ what do you mean The account list is a column in a dataset? So I can understand how to help If this helped, please consider giving kudos and mark as a solution @me in replies or I'll lose your thread Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page Consider voting this Power BI idea Francesco Bergamaschi MBA, M.Eng, M.Econ, Professor of BI265Views0likes1CommentRe: how to combine 2 columns from different data sets in 1 new dimension
Hi Emmy88_ you can do that both in Power Query or in DAX In DAX: Go to Modeling - New Table Write this code My combined Dimension = UNION ( Dimension1, Dimension 2) If you prefer a Power Query solution, just go (in Power Query) to to Home - Append Queries - apend Query as New and then select the two dimensions If this helped, please consider giving kudos and mark as a solution @me in replies or I'll lose your thread Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page Consider voting this Power BI idea Francesco Bergamaschi MBA, M.Eng, M.Econ, Professor of BI293Views1like3CommentsRe: Utterly perplexed why I'm getting error messages when refreshing this model
Hello masplin I uploaded the file. The problem was due to calculated columns and relationships (again, circular references). If this helped, please consider giving kudos and mark as a solution @me in replies or I'll lose your thread Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page Consider voting this Power BI idea Francesco Bergamaschi MBA, M.Eng, M.Econ, Professor of BI536Views0likes0CommentsRe: Utterly perplexed why I'm getting error messages when refreshing this model
Hello again I know that because, while trying to delete (not disable) all relationships, I got many error messages of circular reference between columns and tables. I had to delete a lot of calculated columns and, once those errors vanished and I could delete the last relationship, the refresh was successful. Where can I upload the file successfully refreashed with the modified queries? Best If this helped, please consider giving kudos and mark as a solution me in replies or I'll lose your thread Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page Consider voting this Power BI idea Francesco Bergamaschi MBA, M.Eng, M.Econ, Professor of BI679Views0likes4CommentsRe: Restrict access to a specific report page for different user groups
There is no page security in Power BI The only way to get something similar is using Apps BUT that only LOOKS like page security but it is not: it only prevents one or more users from seeing a page but if another user (with the app that shows the page hidden to the others) sends the link to the users not able to see it, they will then see the page Only security is RLS and OLS To secure pages you need different workspaces and therefore different apps Best If this helped, please consider giving kudos and mark as a solution me in replies or I'll lose your thread Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page Consider voting this Power BI idea Francesco Bergamaschi MBA, M.Eng, M.Econ, Professor of BI320Views0likes0CommentsRe: Utterly perplexed why I'm getting error messages when refreshing this model
Hi masplin the problem is some circular reference somewhere I disabled the load of the query MSOA_Mappping query and now the problem is indicated to be somewhere else Mu suggestion: - disable all relationships in Power BI between tables - try to load queries again Please let me know if this solves, then you can rebuild the model I am not sure what is casuing this but at least we know it is not specific to Power Query: it is a problem when the refresh is finished and the model gest updated Hope I helped If this helped, please consider giving kudos and mark as a solution @me in replies or I'll lose your thread Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page Consider voting this Power BI idea Francesco Bergamaschi MBA, M.Eng, M.Econ, Professor of BI696Views0likes6Comments
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.