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
    )
harshadrokade's avatar
harshadrokade
Post Partisan
4 years ago

HI Ashish_Mathur  Can youp pls help me on above. Its the smilar table for which you helped me on last query.