Forum Discussion

MSiwek's avatar
MSiwek
Icon for Helper I rankHelper I
1 year ago

Matrix in PowerBi shows same values for each row

Hi All, I have a problem with connections/measure because my simple measure shows same value for each row.  I'm using "Nazwa grupy" from "Zmiany" Date from "Kalendarz" and my measure is in values: ...
Need Help
Deku's avatar
Deku
Icon for Super User rankSuper User
1 year ago

Added keepfilters to intersect the current a calculated filter contexts.

 

Ilość serwisów = COUNTROWS(

    Keepfilters(

FILTER(

        SAX,

        (SAX[SVCDATECREATED].[Rok] = 2024 || SAX[SVCDATECREATED].[Rok] = 2025) &&

        NOT(ISBLANK(SAX[SERVICE]))

    )

)

)

MSiwek's avatar
MSiwek
Icon for Helper I rankHelper I
1 year ago

Deku information below:

 

KEEPFILTERS function can only be used as a top level filter argument of CALCULATE and CALCULATETABLE or with a table argument of a function performing a table scan.

  • Deku's avatar
    Deku
    Icon for Super User rankSuper User
    1 year ago

    Ilość serwisów =

    Calculate(

    COUNTROWS( SAX ),

    Keepfilters(

    FILTER(

    SAX,

    (SAX[SVCDATECREATED].[Rok] = 2024 || SAX[SVCDATECREATED].[Rok] = 2025) &&

    NOT(ISBLANK(SAX[SERVICE]))

    )

    )

    )

    • MSiwek's avatar
      MSiwek
      Icon for Helper I rankHelper I
      1 year ago

      Same result as in my first measure.