countif in Power BI

Hi Anonymous ,

However if you wish to create a new table, and not a visualization, the easist way is to go back to your original query, rename it. Then

delete the columns you don't want in the new table, (like ID) move the month column and rename it. Then pivot the columns.

Added a picture showing the pivot step. Highlight the Domains column (in my table) and click on Pivot Columns, choose the values I have selected.

Finally add a column called TotalMonth with the totals of the two domain columns.

See my picture below for the code using Adv Editor as well as the final table. If you refresh, this new table will be refreshed as well.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

Hi Nathaniel_C ! Thank you very much for putting effort into my small thing :)

I will try to make it only with visualization, as I see creating a table requires more knowledge.

I would have one more question. Actually I would like to make visualization out of this: showing the monhtly average / domain.

Here is the matrix (numbers are different):

And I would like to create some visualization like this, but showing the avg per domain (IT, NW). I could do the total avg with a measure like this:

Shall I make measures or is there an easier way to show the avg numbers per domain? Best would be to have a treemap but not with totals but with avg. This is with totals, I could not find how to turn it into avg: