Forum Discussion

bh98381's avatar
bh98381
Regular Visitor
7 years ago

Circular Dependency

I have a DAX pattern that I've used in several projects for data grouping but I'm running into an issue with it now.     I have a look up table that I use to retrieve a data group in this case SPRa...
Need Help
v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

Hi bh98381 ,

 

Hope this case can help you. I recomend your to write measures instead of calculated columns here. If it doesn't solve your issue. Kindly share your sample data to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

 

 

bh98381's avatar
bh98381
Regular Visitor
7 years ago

Thanks  v-frfei-msft for your recomendation.

 

When I enter SP Range as a Calculated Columns I get the desired result and when I enter SPRangeSort as a measure there is not an error.  The issue with this is that I'm not able to use SPRangeSort as a Sort by Column for SP Range when it is a meaure.

 

When I enter SP Range as a Measure instead of a Calculated Column I am not able to use SP Range as a Slicer.

 

I'll need both of theses to be Calculated Columns.  I have this pattern workng in other PBIX files.