Need help please. I need to to COUNT column ID if Sum of column A or column B hits a thresh-hold.
Hi. I need some help please.
I need to count column ID if the SUM of column A is greater than 25 or column B is greater than 250. There are duplicate IDs in the dataset, so if the SUM of column A or column B for these duplicate IDs are above the thresh-hold then it should be counted, not individually.
I have attached a link to the Power BI file. For the dataseset in the file, the number I am looking for is: 24