I would like to Sum sale by filter other like this
Go to Solution.
Hi @nontmn ,
Based on your original formula, I modified it to calculte the values.
Column 4 = DIVIDE(CALCULATE(SUM('Table'[A]),FILTER('Table',EARLIER('Table'[model])='Table'[model])),'Table'[A])
Is this what you want? If not, can you please post the expected result? Then we will understand your requirement clearly.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
SUM ( ZGI[sale] ),
FILTER ( ZGI, ( ZGI[model] ) = EARLIER ( ZGI[model] ) )
Thank you It's working but when I use in another column for sum another thing it show
"a circular dependency was detected"
I have to make fomular like this for 3 column
What formula did you use?
If you could copy paste some sample data and expected results, it will help in finding an appropriate solution
As a sample see the below post
column1 = CALCULATE (SUM ( ZGI[sale] ),FILTER ( ZGI, ( ZGI[model] ) = EARLIER ( ZGI[model] ) ))
and next I create column 2 like this
column2 = CALCULATE (SUM ( ZGI[GI] )
It show "a circular dependency was detected:ZGI[GI],ZGI[sale],ZGI[GI]"
I don't see any error in your formula
Could you share your file?
What are you trying to achieve with
if your Table rows are different then above formula and column2 = ZGI[GI] would yield same results
I create new file to compare issue at "Column 4"
I checked your file. What is your desired output in Column 4?
Actually, I have many version for one model so sometime I cannot indicate version, it has to share to other version.
My idea is create column that already shared sales by month and model but when I create another column with same method it show circular dependency detected(sum column[A]).
I already use measure method to share version but I found something wrong (subtotal sum up) . So I think it better to share before next calculation by measure.
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.