Forum Discussion

rizalm38's avatar
rizalm38
Frequent Visitor
5 years ago
Solved

Multiple Filter and multiple criteria

Hi BI Master(s), I have a big tabular data set as shown below (table name = Cement): SampleName Oxides Value Rawmeal CaO 50 Clinker C3S 62 Clinker F.CaO 1.2 KilnFeed Al2O3...
  • Payeras_BI's avatar
    Payeras_BI
    5 years ago

    Hi rizalm38 ,

    You could try this way:

    DataIN = 
CALCULATE(
COUNTROWS('Cement'),
('Cement'[Oxides]="C3S" && 'Cement'[Value]>=58)||
('Cement'[Oxides]="F.CaO" && Cement[Value]<=1.8)
)

     

Payeras_BI's avatar
Payeras_BI
Icon for Solution Sage rankSolution Sage
5 years ago

Hi rizalm38 ,

You could try this way:

DataIN = 
CALCULATE(
COUNTROWS('Cement'),
('Cement'[Oxides]="C3S" && 'Cement'[Value]>=58)||
('Cement'[Oxides]="F.CaO" && Cement[Value]<=1.8)
)

 

rizalm38's avatar
rizalm38
Frequent Visitor
5 years ago

Thank you Payeras_BI , it's almost perfect solution but I need to use AND (&&) function instead OR (||). Maybe there is another way to solve my problem?