Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Create a filter with a measure.

Hello all!  Is there a way to create a filter in the form of a measure? I want to write like this: Measure = CALCULATE( expression, [Filter Measure] ) Is there a similar way to do ...
Need Help
Kumail's avatar
Kumail
Icon for Impactful Individual rankImpactful Individual
5 years ago

Hello Anonymous 

 

You can upload it to the drive and send the link here. 

 

I hope this helps.

 

Regards

Kumail Raza

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Kumail What if the data is confidential?
Do I rewrite the entire file?
I apologize for my insufficient knowledge.

  • Kumail's avatar
    Kumail
    Icon for Impactful Individual rankImpactful Individual
    5 years ago

    Anonymous Don't worry 🙂

    You can annoymize the data and just send the drive URL to the sample file.

     

    Regards

    Kumail Raza

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Kumail Okay how do I do that if the data set comes in as a directquery?

      • Kumail's avatar
        Kumail
        Icon for Impactful Individual rankImpactful Individual
        5 years ago

        Anonymous 

        The best thing here is to branch out your scenario data into a separate file.

         

        You can filter down the data into very small amount and then export it to excel and then reload the data into another model and set it up exactly the same way as in your original model.

         

        The good thing about it is the techniques are exactly the same, you can have just 0.1% of data or even less and it will exactly be the same solution. 

         

        Hope this helps.

         

        Regards

        Kumail Raza

        MS Power BI Community: community.powerbi.com/t5/user/viewprofilepage/user-id/22640