Creating a Measure for a Gauge Visual

[Anonymous]

I'm wanting to create a measure so that I can use a gauge visual to see how many devices come under a certain group out of the total number of devices.

I am struggling to do this as the group is selected by a filter on my table. For example, I have a table full of devices and I know there is 1.6k devices for 'FG' when I filter the table to just show devices under that name and there is 36k devices in total (With no filter). So how do I create a measure to show the 1.6k 'FG' devices out of the 36k total devices so I can then use a gauge visual.

All I've managed to do is create a measure to show the amount of devices that comes under the filter in that column, but it doesn't show the total amount too so my gauge visual currently just shows 1.6k devices and not 1.6k devices out of 36k.

Thanks.

[Anonymous · Accepted solution]

Hi @Anonymous 

A late reply.

If you want to display the number of specific groups in the total in the dashboard visual, you also need to calculate the total and put it in the dashboard visual.

Create measures.

Total = 
    CALCULATE(
        COUNTROWS('Table'),
        ALL('Table')
    )

Select OpCo = 
IF(
    ISFILTERED('Table'[OpCo]),
    CALCULATE(
        COUNTROWS('Table'),
        'Table'
    ),
    0
)

Create a Gauge Visual.

Here is the result.

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @Anonymous

Please provide sample data that fully covers your issue and the expected outcome based on the sample data you provided.

Regards,

Nono Chen

[Anonymous]

Hi @Anonymous,

I am playing with a lot of data so can't show all of it. But essentially my data is an excel spreadsheet full of devices. I want to use a gauge visual to show that there is 1.6K FGSGlobal devices out of the 39k that is in my dataset. I will create a sample table below, but please bare in mind that there is a lot more columns, I am just highlighting the columns I would need to use in my measure (Entity ID and OpCo). OpCo would need to be filtered so that only FGSGlobal devices are counted and then I would also need a total count within the measure so the visual would show 1.6 out of 39k.

Entity ID	Name	OpCo
323321333	Katie's Macbook	FGSGlobal
556324532	Laptop	WT
446522442	David's Macbook	FGSGlobal
446578755	Laptop	DTI