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
murali5431's avatar
murali5431
Helper III
5 years ago

Hi,

I found your solution to be useful, but I am not clear how I can modify it to suit my requirement. My current report builder query is as below:

EVALUATE SUMMARIZECOLUMNS('DataforPL'[CNTR], 'DataforPL'[CNTR_DT], 'DataforPL'[SUPP_LD_NO], RSCustomDaxFilter(@DataforPLCNTR,EqualToCondition,[DataforPL].[CNTR],String), RSCustomDaxFilter(@DataforPLCNTRDT,EqualToCondition,[DataforPL].[CNTR_DT],DateTime), RSCustomDaxFilter(@DataforPLSUPPLDNO,EqualToCondition,[DataforPL].[SUPP_LD_NO],String))

 

I have 3 parameters in above query above. I need to modify it such either I enter a combination of [CNTR] & [CNTR_DT] or enter just enter [SUPP_LD_NO] as the parameter, leaving other two fields blank.

 

Hope I was clear with my requirement. Thanks to assist.

 

Regards,

Muralidhar

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!!