Forum Discussion

harshadrokade's avatar
harshadrokade
Post Partisan
4 years ago
Solved

DAX filter help needed

Hi,   I have table as Vendordata (See at bottom). There is other table which has Vendor names as well (Vendorlist) & a slicer is created based on Vendor name from Vendorlist table. Vendordata & Ven...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    Does this work?

     

    MS-original1 =
VAR SelectedVendor = SELECTEDVALUE ( 'Vendorlist'[Vendor name] )
RETURN
    CALCULATE (
        COUNT ( 'Vendordata'[Secondary Vendor] ),
        ALL ( 'Vendorlist' ),
        'Vendordata'[Secondary Vendor] = SelectedVendor
    )
AlexisOlson's avatar
AlexisOlson
Super User
4 years ago

Does this work?

 

MS-original1 =
VAR SelectedVendor = SELECTEDVALUE ( 'Vendorlist'[Vendor name] )
RETURN
    CALCULATE (
        COUNT ( 'Vendordata'[Secondary Vendor] ),
        ALL ( 'Vendorlist' ),
        'Vendordata'[Secondary Vendor] = SelectedVendor
    )
  • harshadrokade's avatar
    harshadrokade
    Post Partisan
    4 years ago

    Thanks a lot sir. Appreciate your help.