Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I have a relatively simple graph I'm trying to create using the following information as below:
Group | Customer ID | Old Rating | New Rating | Rating Difference | Downgrade/Upgrade |
Automotive | ABC1234 | 3 | 5 | 2 | Downgrade |
Automotive | ADX1234 | 1 | 6 | 5 | Downgrade |
Agriculture | BOD1234 | 4 | 2 | -2 | Upgrade |
Agriculture | SIP1234 | 2 | 2 | 0 | No Change |
Finance | TXN1234 | 5 | 2 | -3 | Upgrade |
Finance | POQ1234 | 9 | 10 | 1 | Downgrade |
Travel | QTR1234 | 4 | 1 | -3 | Upgrade |
Travel | POX1234 | 3 | 2 | -1 | Upgrade |
However, stuck on knowing which DAX code to start with to create something similar to this:
The X-Axis will remain the same, with the difference being the Y-Axis.
How can I make the Y-axis utilise a count, so that I can show that:
Solved! Go to Solution.
@Anonymous ,
for visual
new measure = divide((sumx(Table,switch(true(), [Rating]-[New Rating]>0,1, [Rating]-[New Rating]<0,-1,0)),count(Table[Customer]))
or %
Downgrade % = divide(countx(filter(table,Downgrade/Upgrade="Downgrade"),Table[Customer]) ,count(Table[Customer]))
Upgrade % = divide(countx(filter(table,Downgrade/Upgrade="Upgrade"),Table[Customer]) ,count(Table[Customer]))
@Anonymous ,
for visual
new measure = divide((sumx(Table,switch(true(), [Rating]-[New Rating]>0,1, [Rating]-[New Rating]<0,-1,0)),count(Table[Customer]))
or %
Downgrade % = divide(countx(filter(table,Downgrade/Upgrade="Downgrade"),Table[Customer]) ,count(Table[Customer]))
Upgrade % = divide(countx(filter(table,Downgrade/Upgrade="Upgrade"),Table[Customer]) ,count(Table[Customer]))
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
93 | |
86 | |
80 | |
69 | |
68 |
User | Count |
---|---|
226 | |
129 | |
119 | |
83 | |
77 |