Sumif formula

[janalu]

Hello, I am trying to replicate sumif formula from excel highlighted in green below to power Bi but it does not work. Could you please advice? Formula form excel is: =SUMIF($E$2:$E$38;">="&E2;$E$2:$E$38)/SUM($E$2:$E$38)

Many thanks

Jana

[Anonymous]

As I understand, you want to get running Total of your Sales percentage  in Total Percentage.

You can achieve it through quick measure option.

I have also pasted the code below.

Sales% running total in Sales% =

CALCULATE(

    SUM('Table1'[Sales%]),

    FILTER(

        ALLSELECTED('Table1'[Sales%]),

        ISONORAFTER('Table1'[Sales%], MAX('Table1'[Sales%]), ASC)

    )

)

[Ashish_Mathur]

Hi,

Looks like you want to compute cumulative % i.e. F2 = F1+E2 and dragged down.  Am i correct?  Share the link from where i can download your PBI file.

[janalu]

Hi Ashish, yes that´s right! Could you please help me with the formula? Let me know if you can open the link below:

https://app.powerbi.com/groups/me/reports/68183f01-f29c-463d-bd0f-101f4e1f4a26?ctid=e0793d39-0939-49...

Thanks,

Jana

[Ashish_Mathur]

Hi,

I cannot download the PBI file from there.

[janalu]

https://drive.google.com/open?id=1gj4uOZMaIC2fohKO6bWdwUUjPg1ZX5of

What abou this one?

[Ashish_Mathur]

Hi,

That seems to be a very big file.  Please share the download link of the abridged version (a couple of MB's only).

[Greg_Deckler]

To emulate SUMIF you use CALCULATE with a SUM and a FILTER clause.