Forum Discussion
dax
- 2 years ago
Hi Anonymous
If i understood you correctly the measures to use are :
1.% Actual = sumx('Table',DIVIDE([Sale],[TGT]))2.flag = if([% Actual]>1,1,0)3.counter = SUMX(SUMMARIZE(VALUES('Table'[STL]),"Counter_1", CALCULATE(COUNTROWS('Table'),FILTER('Table',[flag]=1))),[Counter_1])Result :
pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
- 2 years ago
Anonymous
60K is not so huge..if you are using an import mode.
If the report isn't working with the formula with the virtual table.
Try to use a calculated column.Actual % = divide('Table'[Sale],[TGT])and for counting the measure :
count_2 = CALCULATE(COUNTROWS('Table'),'Table'[Actual %]>1)the updated pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi Anonymous
If i understood you correctly the measures to use are :
1.
pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
- Anonymous2 years agoNot applicable
Hii Ritaf1983
I have 60k STL's. And this formula is not working for huge data.- Ritaf19832 years agoSuper User
Anonymous
60K is not so huge..if you are using an import mode.
If the report isn't working with the formula with the virtual table.
Try to use a calculated column.Actual % = divide('Table'[Sale],[TGT])and for counting the measure :
count_2 = CALCULATE(COUNTROWS('Table'),'Table'[Actual %]>1)the updated pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly