Forum Discussion

natolira's avatar
natolira
Frequent Visitor
8 years ago

Implicit Calculate in a Power BI Report

Hello. I have some doubts about the order of evaluation of the implicit CALCULATE when you create a Power BI report using those external filters available whenever you call a [Measure] within it.

 

Is this order correct?

 

[PBI implicit filters] =
CALCULATE (
    CALCULATE (
        CALCULATE (
            CALCULATE (
                [Measure],
                CurrentVisualRowsAndColumnsAlreadyFilteredByPreviousFilters
            ),
            CurrentVisualLevelFilter,
            OtherVisualsFilter
        ),
        DrillThroughFilter,
        PageLevelFilter
    ),
    ReportLevelFilter
)

 

 

1 Reply

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Icon for Microsoft Employee rankMicrosoft Employee

    Hi natolira,

     

    Very interesting formula! And the order also looks right to me. :smileyhappy:

     

    Regards