Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |