Measure for Selected Value from Slicer with Default value from a table

[GR83]

I have 2 tables one is GenerateSeries(0,20,1)

Other is 

City                     Qty

Atlanta                5

Albany                 2

Detroit                 6

New York             12

I have a Single select City Slicer (ex. Detroit Selected) 

I have another slicer based in Geterated Series (1-20) 

I need a measure if the Geterate series slicer is selected then I need Series value else Detroit Qty which is 6   

[Anonymous · Accepted solution]

Hi @GR83 

For your question, here is the method I provided:

Here is the data you provided：

“City”

“GenerateSeries”

Create a measure, determine whether “GenerateSeries" slicer is selected and return the value in GenerateSeries

Result = 
   IF(
    ISFILTERED('GenerateSeries'[Value]),
    SELECTEDVALUE('GenerateSeries'[Value]),
    SUM('City'[Qty])
    )

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.

[PijushRoy]

Hi @GR83 

Yesterday I posted this comment for Hierarchy Slicer
Can you see the post and download the PBIX file and apply same
https://community.fabric.microsoft.com/t5/Desktop/Slicer-interact-with-each-other/m-p/3615706#M11861...

PBIX
https://drive.google.com/file/d/1f-3D3x_mx0TWFzUXwyw5TDk0bw_qAfQR/view?usp=sharing

If solved your requirement, please mark this answer as SOLUTION.
If this comment helps you, appreciate your KUDOS

Thanks
Pijush