Use outcome of measure on axis

[MiKeZZa]

Hi all,

I have a Power BI table like this:

ProdID             Value A             Value B        Outcome
1                      10                      20                1
2                      1                        20                0
3                      0                        10                2

4                      10                      20                1

So what you see is the result of many records that lead to Value A and Value B, both are measures that sum underlying records. Outcome is also a DAX query that returns 0, 1 or 2, based on dividing Value A on Value B.

Now I want to have a graph or table that says:

Outcome            Count of occurence

0                         1

1                         2

2                         1

But I can't count the outcome of a measure as I see now. Is there a trick for this?

[v-ljerr-msft · Accepted solution]

Hi @MiKeZZa,

If I understand you correctly, an alternative solution could be firstly creating a summarize table with ProdID column and the measures.

Then you should be able to show the Outcome and count of Outcome from the new created table on a Table visual to get the expected result in your scenario.

The formula below is for your reference.

Table =SUMMARIZE ( 'Table1', 'Table1'[ProdID], "Outcome", [Outcome] )

Regards

[MiKeZZa]

Yeah! That works great. Awesome. Thank you very much @v-ljerr-msft!