cancel
Showing results for
Did you mean:
Frequent Visitor

## SumProduct in measure

i am fairly new to this and i created a "dashboard" in excel but know i want to learn how to put it in power bi, i ahve everything else i just need help on this last one.i am creating an "index" in excel i put this formula in =IF(M25=TRUE,"",SUMPRODUCT((\$D\$2: D25=D25)*(\$M\$2:M25<>TRUE))) i would like to transferr that over to power bi. how would i do that?

1 ACCEPTED SOLUTION

Accepted Solutions
Frequent Visitor

no but i got exactly what i want going through the query editor, didn't even have to use index or custom columns! Thanlks for all your help and i apologize for wasting your time on trying to help me.

19 REPLIES 19
Solution Sage

Hi @RCSmart01,

With CALCULATE  and FILTER you can easily process a product with fields( columns).

Please share dummy data and I can make a try...

Ninter

Frequent Visitor

so what i would ike to do is number each item that is in each type but have it start with its own type (see below), i have the filters that i want and removed the items i don't need. So right now i have the items i need. so i want to number the ones that are on screen.

 1 Title 3 Book 2 Title 7 Book 3 Title 11 Book 4 Title 15 Book 5 Title 19 Book 6 Title 23 Book 7 Title 27 Book 8 Title 31 Book 1 Title 1 Movie 2 Title 5 Movie 3 Title 9 Movie 4 Title 13 Movie 5 Title 17 Movie 6 Title 21 Movie 7 Title 25 Movie 8 Title 29 Movie 1 Title 4 Music 2 Title 8 Music 3 Title 12 Music 4 Title 16 Music 5 Title 20 Music 6 Title 24 Music 7 Title 28 Music 8 Title 32 Music 1 Title 2 TV Show 2 Title 6 TV Show 3 Title 10 TV Show 4 Title 14 TV Show 5 Title 18 TV Show 6 Title 22 TV Show 7 Title 26 TV Show 8 Title 30 TV Show
Solution Sage

Hi @RCSmart01,

Your table has no titles ( fields) so I don't know what is item. I can figure out but...

Do you want to count the number of item for every type?

Ninter

Frequent Visitor

oh sorry bout that the column titles are next to buy, titles, and type. and yes count by type

Solution Sage

Hi @RCSmart01,

Then you can use COUNTROWS or COUNTA or a combination with calculate and then you select a table visualisation with type and you have your expected figures.

Frequent Visitor

Sorry i should have been more clear i want to label it title with a number and the number restarts by type. See below, i have created something in tableu, and i want to do the same or similar thing in powerbi. then i am going to filter but the number of the "index"

Solution Sage

Hi @RCSmart01,

The formula still works ( you can combine with calculate with sum).

Did you try it ?

Ninter

Frequent Visitor

i don't know what the format of the forumla is, like i said i haven't used powerbi and still trying to get used to it. What do i put in "Sample"?

Solution Sage

Hi @RCSmart01,

Sample here is the name of my table so you have to replace it by the name of your actual table.

Ninter

Announcements

#### Power Platform Community Conference

Check out the on demand sessions that are available now!

#### Power Platform October Community Highlights

Check out the top community contributors across all of the communities

#### Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors