Forum Discussion
Helper IIHow to create a LOD in Power BI
Hi fereshtehaghaei ,
Please update the formula of calculated column [New-Unit] and check if it can return the expected result...
New-Unit = CALCULATE ( MIN ( vm_rawDataQuestionsOptionsCategories[optionText] ), FILTER ( vm_rawDataQuestionsOptionsCategories, vm_rawDataQuestionsOptionsCategories[responseUniqueID] = EARLIER ( vm_rawDataQuestionsOptionsCategories[responseUniqueID] ) && vm_rawDataQuestionsOptionsCategories[questionID] IN { 740044, 740045, 740076, 740047 } ) )For circular dependencies error, you can review the following blogs to get more details.
Understanding circular dependencies in DAX - SQLBI
Avoiding circular dependency errors in DAX - SQLBI
Circular Dependency between Calculated Columns in ... - Microsoft Fabric Community
Best Regards
Super UserPlease check the forum search, there have been quite a few LOD related questions recently. Power BI does not support the concept of dynamic buckets, you need to provide your own pre-made list.
fereshtehaghaeilbendlin I did look at the Forum before posting and none of the questions or solution were helping to solve my question. And still having no solution even after posting my own questions. Thanks
- lbendlin
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523