Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

dax

BE STL TGT Sale Abhay Chourasiya Abhay Chourasiya 9.853063 77   Dharmendra  Kherwal 81.48438 11   Dinesh  Patil 74.49055 53   Rakesh  Admane 76.77411 34   Ravindra  ...
  • Ritaf1983's avatar
    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

  • Ritaf1983's avatar
    Ritaf1983
    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