Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Dellis81
Continued Contributor
Continued Contributor

Compatibility with ISFILTERED function inside Paginated reporting?

Hello, i have been struggling getting various financial statement subtotals to display within paginated reporting.  Within PBI matrix visual - the income statement is properly presented, but once I take that same measure into paginated - various subtotals are no longer displayed (Cost of Goods Sold, Gross Profit, etc)

 

As I have been attempting to understand, think I have the issued narrowed down to the isfiltered function.    Within hte measure, I have a series of isfiltered(table/column) chained together with the OR operator.    The reason I have this - is to prevent drilldown within the subtotal lines.  I have an if statement- if VarCMfiltered=true, blank, measure.

 

Snippet of the chained isfiltered functions.

VAR SubHeaderFiltered =
    ISFILTERED ( 'ConsolidatedTransactions'[SubHeader] )
VAR ReportLineDescrFiltered =
    ISFILTERED ( 'COA Setup'[Report LineDescription] )
VAR COADescrFiltered =
    ISFILTERED ( 'COA Setup'[Description] )
VAR COASubHeaderFiltered =
    ISFILTERED ( 'COA Setup'[SubHeader.1] )
VAR COAQbooksSubHeaderFiltered =
    ISFILTERED ( 'COA Setup'[Qbooks SubHeader] )
VAR VarCMFiltered = SubHeaderFiltered || ReportLineDescrFiltered
    || COADescrFiltered
    || COASubHeaderFiltered
    || COAQbooksSubHeaderFiltered

However, what I have found, if I remove these isfiltered statements - subtotals are displayed within paginated reports.   with the unfortunate effect of undesired drill down lines.

 

For example, contribution margin and Gross Profit  includes undesired drilldown lines,

 

Dellis81_0-1691778598091.png

 

This screenshot shows the various subtotals as zero - when the isfiltered is true included in measure.  No drilldown is allowed

Dellis81_2-1691779214221.png

Below is a PBI matrix visual, that is working correctly  w/isfiltered functions.

Dellis81_3-1691779499325.png

How can I trick paginated reporting to work similiarly to the matrix visual?   I highly suspect the cause is resulting from the use of isfiltered function?

Thank you!

0 REPLIES 0

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors