'Power BI How to avoid sum of created measure
I have a database contains "Company Names","Purchase Order","Payment Amount". data preview image is below

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;

My expectation from matrix table is "Not to see sum of Hk" . How can I avoid summing Hk ?
Solution 1:[1]
try this one
Hk =
IF(
ISFILTERED( Hakedis_Data[Company_name] ),
MAX( Hakedis_Data[Purchase Order] ),
BLANK()
)
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | bibakcamki |
