Forum Discussion

AadiSingh_2018's avatar
AadiSingh_2018
Regular Visitor
7 years ago

Help needed urgently DAX

Hi Dax is new for Me. I just want to use slicer (ID name) to filter the Doc No. but the same time, I don't want to filter ID Name in Table. Date Doc No_ ID ID Name Amount 04-04-2018 1 AA Joe...
Need Help
Baskar's avatar
Baskar
Resident Rockstar
7 years ago

Try this AadiSingh_2018

 

Total = CALCULATE(SUM(Slicer[Amount]),ALLEXCEPT(Slicer,Slicer[Doc No]))

AadiSingh_2018's avatar
AadiSingh_2018
Regular Visitor
7 years ago
Dear Baskar,

No it is not working, I used your formula but the result is same.

Date	Doc No	ID	Total
43194	1	AA	300
43194	1	BB	300
43367	2	AA	700

it is not showing the ID (CC) in ID column
  • AadiSingh_2018's avatar
    AadiSingh_2018
    Regular Visitor
    7 years ago

    Still Awaiting for help!!!