if countif and sumifs

[Augustas-ase]

My formula in excel is : =IF(COUNTIFS($N$1:N2;N2)=1;SUMIFS(U:U;Q:Q;"<="&Q2;N:N;N2);"")

how to write in PBI ?

Thank you.

[Augustas-ase]

who can help me?

[Augustas-ase]

Thanks for the formula, but everywhere I get an empty result 😕

[Adamboer]

In Power BI, you can create a measure using the DAX language that has similar functionality to the Excel formula you provided. Here's an example of how to write the measure in Power BI:

Measure =
IF(
COUNTROWS(
FILTER(
Table,
Table[N] = MAX(Table[N])
)
) = 1,
CALCULATE(
SUM(Table[U]),
FILTER(
Table,
Table[Q] <= MAX(Table[Q]) && Table[N] = MAX(Table[N])
)
),
BLANK()
)

You'll need to replace "Table" with the name of the table you're working with in Power BI. This measure will return the same results as the Excel formula you provided, but calculated within Power BI.