Power BI How to avoid sum of created measure

[Anonymous]

I have a database contains "Company Names","Purchase Order","Payment Amount". data preview image is below

Data Preview

I try to create matrix table with columns;

Company name: Returns company names, that' s OK

Hk: at how many times I have pay that company, at this point i have a problem

SUM_Payment: sums all payments, that' s ok, see matrix table image below;

I tried to create measure that gives to Hk Sum false for avoding summing (like HASONEVALUE), but B Company has two value so B Company's Hk returns also false...

My expectation from matrix table is "Not to see sum of Hk" . How can I avoid summing Hk ?

[Jos_Woolley · Accepted solution]

Hi,

Try with ISFILTERED:

Hk =
IF(
    ISFILTERED( Hakedis_Data[Company_name] ),
    MAX( Hakedis_Data[Purchase Order] ),
    BLANK()
)

Regards 

[amitchandak]

@Anonymous , use isinscope or isfiltered and try

https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/

if(isinscope(Table[Company Name]), [HK], blank())