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

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