Forum Discussion

dw700d's avatar
dw700d
Icon for Post Patron rankPost Patron
4 years ago
Solved

simple filter measure

I have a list of over 5,000 Purchase order numbers. Each Purchase order can have a variety of different account codes attached to it. There are 14 account codes. I would like to Identify Purchase ord...
Need Help
  • VahidDM's avatar
    VahidDM
    4 years ago

    Hi dw700d 

     

    Try this measure :

    Purchase <>(10C) = 
VAR _Count10C =
    CALCULATE (
        COUNT ( 'Table'[Sum of Amt] ),
        ALLEXCEPT ( 'Table', 'Table'[Purchase Order No] ),
        'Table'[Acct Cd] = "10C"
    )
RETURN
    IF ( ISBLANK ( _Count10C ), 0, _Count10C )

     

    and filter the new meausre to show zero.

    Output:

     

     

    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

    Appreciate your Kudos✌️!!

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

dw700d , Plot this as total or with purcahse order no

 


Measure =
var _1 = calculate(sum(Table[Amt]), filter(Table, Table[Acc Cd] ="10C"))
return
countx(values(Table[Purchase Order No]), if(isblank(_1) ,[Purchase Order No], blank()))