Forum Discussion

JimJim's avatar
JimJim
Icon for Responsive Resident rankResponsive Resident
6 years ago

Paginated Report - filtering a dataset

Hi Guys,

 

I have a paginated report that displays finance data, the report has the following 2 parameters:

 

Division

Region 

 

I only want the data set to filter on Region, if Division = '300'. If the user selects a division that is not 300, then Region filter should be ignored.

 

I have added the following filter to my data set, the problem I have is that the Region parameter does not work at all.

 

SELECT LocationId
FROM BusinessHierarchy
WHERE Region IN (@Region) Or
@Division <> '300'

 

My data set filters on LocationId

 

Any help would be appreciated.

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    JimJim , Try a measure like this with location ID

    if(max(BusinessHierarchy[Division] , calculate(count(BusinessHierarchy[LocationId]),all(BusinessHierarchy[Division]), filter(all(BusinessHierarchy[Region]), BusinessHierarchy[Region] in values(BusinessHierarchy[Region]))) ,calculate(count(BusinessHierarchy[LocationId]),all(BusinessHierarchy[Division]),all(BusinessHierarchy[Region])))

    • JimJim's avatar
      JimJim
      Icon for Responsive Resident rankResponsive Resident
      6 years ago

      Hi amitchandak , Thank you for your reply. But, this is a paginated report using Power BI report builder, I don't think it's possible to do what you suggest.

       

      Also, I may have created this topic in the wrong forum (apologies if so)