cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
subhashree_r Frequent Visitor
Frequent Visitor

Like for Like Analysis Slicer

Hey People,

    I would like to achieve a slicer for Like for Like Analysis. Given a image below for reference.Capture 7.PNG

If the enable is selected then

1. stores that were newly opened in the current year should not show.

2. stores that were closed in the previous year should also be eliminated.

For Eg:

Consider I have 10 stores in 2016 (Previous Year)

        1. I closed one of these stores 

 In 2017(Current Year)  I opened three new stores 

Now when I compare CY Vs PY along with the enable slicer on then I should have comparison between the 9 stores that were present in the previous and also present in the current year only.

4 REPLIES 4
v-joesh-msft New Contributor
New Contributor

Re: Like for Like Analysis Slicer

Hi @subhashree_r ,

You can create a calculated column like the following:

EnableDisable =
VAR TA =
    CALCULATE (
        DISTINCTCOUNT ( 'Table'[Year] ),
        ALLEXCEPT ( 'Table', 'Table'[Stores] )
    )
RETURN
    IF ( TA = 1, "Enable", "Disable" )

Here is a demo, please try it:

https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/Eb4--Bszl6JNsuaysv... 

Best Regards,

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

 

Highlighted
subhashree_r Frequent Visitor
Frequent Visitor

Re: Like for Like Analysis Slicer

Hey @v-joesh-msft ,

   I'am finding it difficult to understand the concept associated with the dax, can you please guide me in understanding the same.

subhashree_r Frequent Visitor
Frequent Visitor

Re: Like for Like Analysis Slicer

Another thing about this visual is I would not want to use multiple measure for induvidual visuals rather a single slicer selection that would filter down the entire data to just the stores that comply to Like For Like Aanlysis.

v-joesh-msft New Contributor
New Contributor

Re: Like for Like Analysis Slicer

Hi @subhashree_r ,

My demo is based on what you describe and what your model might look like. Could you share your sample data so that it can help solve the problem better?

Best Regards,

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

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)