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.
I need to display a grid which uses two axes to show a total (by count) of occurrences of 2 values. To make it a little more complicated one of those values is a range of number.
Looking at the sample data i need to count the total occurrences of:
Sev 5 with CVSS 0.0-3.9
Sev 5 with CVSS 4.0-6.9
Sev 5 with CVSS 7.0-10
Sev 4 with CVSS 0.0-3.9
Sev 4 with CVSS 4.0-6.9
Sev 4 with CVSS 7.0-10
Sev 3 with CVSS 0.0-3.9
Sev 3 with CVSS 4.0-6.9
Sev 3 with CVSS 7.0-10
And so on for Sev 2 and Sev 1
It would look something like this:
I have done this with by creating cards and applying manual filters to the values already in the table however since the filters are applied manually at the time i create the card this does not work if a new value appears in the table. For example, when i apply the filter to the card there is no 5.5 to select but later a fresh import brings in a 5.5 but the card doesn’t include that value.
I’m thinking maybe a calculated sum based on the Sev number (e.g. 5) and a range for CVSS (e.g. 0.0-3.9). Then i just put that into the card.
Any suggestions on how i do this?
@lfk32 , A new column like this can help
cvss Range =
SWITCH (
TRUE (),
[cvss] >= 0.0 && [cvss] <= 3.9, "0.0-3.9",
[cvss] >= 4.0 && [cvss] <= 6.9, "4.0-6.9",
[cvss] >= 7.0 && [cvss] <= 10.0, "7.0-10",
BLANK ()
)
Then with Sev name columna and measure countrows(Table) can help
I think i worked out a way but still interested to hear ideas. Maybe someone knows a more streamlined way to do it
User | Count |
---|---|
85 | |
75 | |
71 | |
69 | |
55 |
User | Count |
---|---|
98 | |
96 | |
92 | |
78 | |
70 |