Forum Discussion

fereshtehaghaei's avatar
fereshtehaghaei
Icon for Helper II rankHelper II
2 years ago
Solved

How to create a LOD in Power BI

Hello, My comapany migration from Tableau to Power BI. I have the following Fixed LOD in tableau, which creates a new field based on response ID and and IF OR expression (question ID) and then it r...
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
2 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

fereshtehaghaei's avatar
fereshtehaghaei
Icon for Helper II rankHelper II
2 years ago

Thank You for looking into this and the new update. I did try that table name that you mentioned but I still got the "Circular Dependecy" error. I will review the blogs you have had shared. Thank You