cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

## Count the number of Publishers per State

Good afternoon, I'm working on a project and I've stuck on this formula

I have a table with Publishers and another table with States

how can I make a new measurement where I count the number of Publishers there are by States.

1 ACCEPTED SOLUTION

Thank you very much for your answer, yesterday when I made the post I was able to solve it on my own. It was simple, I thought I should have more arguments. I'm doing a project for a course (which leaves a lot to be desired) and at times I find myself lost in formulas, but here I found a great place.

I did it this way (taking into account my tables) : Suma_Editoriales = DISTINCTCOUNT('Database'[Publishers])

2 REPLIES 2

Thank you very much for your answer, yesterday when I made the post I was able to solve it on my own. It was simple, I thought I should have more arguments. I'm doing a project for a course (which leaves a lot to be desired) and at times I find myself lost in formulas, but here I found a great place.

I did it this way (taking into account my tables) : Suma_Editoriales = DISTINCTCOUNT('Database'[Publishers])

Super User

@Syndicate_Admin , if they are joined with each other, just create a count to countrows measure and use with state

example

COUNT =

COUNTROWS(Publishers)

You can also consider allexcept
Count of Publishers by State =
CALCULATE(
COUNTROWS(Publishers),
ALLEXCEPT(States, States[StateName])
)

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.