Forum Discussion

niirusan's avatar
niirusan
Frequent Visitor
3 years ago
Solved

Cannot Filter on Calculated Tables with Measures

Hi Guys, I have been stumped for days trying to figure out how to get the correct result. I am sure I cannot see the wood for the trees and nothing I try seems to work. I am sure there must be a sim...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    niirusan , calculated Tables and columns can not use slicer values. so no benefit of filtering them with meausre.

     

    A var table inside the measure can get filtered

amitchandak's avatar
amitchandak
Super User
3 years ago

niirusan , calculated Tables and columns can not use slicer values. so no benefit of filtering them with meausre.

 

A var table inside the measure can get filtered

niirusan's avatar
niirusan
Frequent Visitor
3 years ago

HI amitchandak ,
Thanks for your response. I am not quite sure what you mean. Is 'supplier_group' not a var table?

VAR supplier_group = 
ADDCOLUMNS (
VALUES(QCInspections[Supplier_Code]),
"@Group", [GroupSupplier] )

 If not, then what is?

Apologies if this is a DAX 101 question?