Forum Discussion

Shri's avatar
Shri
Frequent Visitor
6 years ago

OR condition between multivalue parameters

I am replicating   a power bi report on paginated Report Builder that has multiple slicers (or parameters), namely Sales Region, SalesType, State, Model_Name, Serial_Number, etc. When we run the repo...
report builder
Hariharan_R's avatar
Hariharan_R
Solution Sage
5 years ago

Hi Murali,

   Try like below. You may need to handle "ALL" (blank) is no value is passed. 

SUMMARIZECOLUMNS (
        'Data'[CNTR], 'Data'[CNTR_DT], 'Data'[SUPP_LD_NO],
FILTER (
Data,
(FORMAT ( Data[CNTR_DT], "YYYY-MM-DD" )
<= FORMAT ("2020-01-01", "YYYY-MM-DD" )
|| (PATHCONTAINS ( "A", DATA[CNTR] )))
|| PATHCONTAINS ("1ABC", DATA[SUPP_LD_NO])
))
 
Thanks
Hari
  • Hariharan_R's avatar
    Hariharan_R
    Solution Sage
    5 years ago

    If my answer helps you, Mark my post as a solution!!