Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to 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
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
User | Count |
---|---|
98 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
58 |