Gauge visual with slicer for actual vs target

[evebarratt]

Hi,

I used below dax to compare target with actual numbers in a default gauge visual.

------------------------------------------------------------------------------------------------------

Target by Consultant =

var Consultant = SELECTEDVALUE('table1'[Consultant Name])

return

CALCULATE(SUM('Table 2'[Target]),'Table 2'[Consultant]=Consultant)

------------------------------------------------------------------------------------------------------

and there is a slicer linked to 'table1'[Consultant Name] so i can filter other visuals by consultants.

The problem is that when I select one consultant, target is working but if the selection is all or more than 1 consultant, Gauge doesn't show the target.

Anyone can help?

[Fowmy · Accepted solution]

@evebarratt 

I believe you do not have a relationship between these two table, 

You can modify your meaure as follows:

Target by Consultant =
CALCULATE(
    SUM('Table 2'[Target]),
    KEEPFILTERS(TREATAS( VALUES( 'table1'[Consultant Name] ), 'Table 2'[Consultant]))
)

[evebarratt]

There is a relationship between 2 tables but i think because of SELECTEDVALUE it wasn't working. Your new measure is working. Thank you!

[VahidDM]

Hi @evebarratt 

Is there any relationship between Table1 and Table2? if there is a relationship between 'table1'[Consultant Name] and 'Table 2'[Consultant], just use SUM('Table 2'[Target]).

The problem is, SELCTEDVALUE works if you select only one value; otherwise, it shows blank. 

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

Appreciate your Kudos!!