Forum Discussion
How to create a LOD in Power BI
- Anonymous2 years ago
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
measure =
calculate (
min ( 'YourTable'[Response] ) ,
ALL('YourTable'[Response Unique ID]),
'YourTable'[Question ID] = 701998 || 'YourTable'[Question ID] = 774063
)
let me know if it works for you .
If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly. I would appreciate hitting that kudos button 👍🤠