Filtering data through measure

[gauravnarchal]

Dear All - I need your help!

I want to exclude all "FEE" transactions from the display and show them next to the rate column for each invoice when any vendor is selected.

So basically "FEE" number or Vendor Name JKG International should not show in any row and instead show total fees as a separate column against each Invoice. If there is no fee then it should show 0. 

Can I create a measure for this requirement?

Please Click Here for the sample report.

Many thanks for your help in advance.

[v-angzheng-msft · Accepted solution]

 Hi, @gauravnarchal 

Try to create a measure below:

_Result =
VAR _FEE =
    CALCULATE (
        MAX ( 'data_New'[Rate] ),
        FILTER (
            ALL ( 'data_New' ),
            'data_New'[InvoiceNumber] = MAX ( 'data_New'[InvoiceNumber] )
        ),
        'data_New'[Number] = "FEE"
    )
RETURN
    IF ( ISBLANK ( _FEE ), 0, _FEE )

Then filter the fee to get the final result.

Result:

Please refer to the attachment below for details

Is this the result you want? Hope this is useful to you

Please feel free to let me know If you have further questions

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

[v-angzheng-msft]

Hi, @gauravnarchal 

Unfortunately, the link above is not accessible.

Could  you post sample data and expected result so it is clear on what needs to be implemented?

If it's convenient for you, it's best to provide a simple sample file without any sesentive information.

Thank you .

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

[gaurav-narchal]

@v-angzheng-msft  - Please click here to access the sample data.  Let me know if you are still not able to access.

Thanks

Gaurav

[amitchandak]

@gauravnarchal , No able access the file.  Ways to filter. are visual level filter or filer using values or summarize

sumx(values(Table[Group by]), if([measure] >20, [measure], blank()))

sumx(summarize(Table, Table[Group By1], Table[Group by1], "_1", [Meausre]), if([_1]>20, [Measure] , blank()))