Forum Discussion

Rookarumba's avatar
Rookarumba
Helper III
7 years ago

Help-Disconnected Measure Filter

Hi Everyone,   I've been trying to figure out this issus for weeks but I seem to hit deadend all the time and hoping to get some help here. I know that a disconnect table is needed but I just can'...
Need Help
v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

Hi Rookarumba,

 

If I understand your scenario correctly that you want to create a slicer to allow users click "Purchase" and “Unpurchase”.

 

What about creating the calculated column with the formula below?

 

Column = IF(CALCULATE(SUM(Table1[Sales]))>0,"purchase","unpurchase")

You could have a reference of the attachement.

 

If you still need help, please share a share a dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)

 

Best Regards,

Cherry

Rookarumba's avatar
Rookarumba
Helper III
7 years ago

v-piga-msft, Thanks, let me look at it first and get back to you when i'm back in the office tomorrow

 

Is not possible to do calculated column since "Purchase" & "unpurchase" is determined by Sales_File thus only "Purchase" can be created by calculated column.

 

There is a master product list file that have all the products and that determine if a customer has "Purchase" or didn't purchase the product. 

 

Let me look at my data model and masked the confidential details. I prob post it over the weekend

 

Thanks :)

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    7 years ago

    Hi Rookarumba,

     

    Have you solved your problem?

     

    If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

     

    If you still need help, please share your data sample and your desired output so that we could help further on it.

     

    Best  Regards,

    Cherry

    • Rookarumba's avatar
      Rookarumba
      Helper III
      7 years ago

      v-piga-msft, sorry for the late reply. Nope, the earlier solution didn't help with my case.

       

      I'm preparing a sample data so i can send it over by the end of the week but is there a email i can send so i can send the original copy?

       

      Sorry for the delay

      • Rookarumba's avatar
        Rookarumba
        Helper III
        7 years ago

        v-piga-msft

         

        Super sorry for the delay. Here is the link

        https://www.dropbox.com/s/s7fsnkz9mkuv0e5/Disconnected_SilcerWmeasure.pbix?dl=0

         

        The scenario is, I've to create multiple year, side by side against the products (Like in the example)

        And the "Purchase/UnPurchase" is refering to 2013, as that is our main focus for the existing year.

         

        We need to create a filter for "Purchase/Unpurchase" for 2013 so user can quickly glance through or export the data which is being narrowed based on Purchase or Unpurchase

         

        Hope that help explain my situation