sum total except for repeating rows
Hello community, I need a measure that sums follower_count and following_count (VALUE Column). I use some simple measures for this. However, this calculation should not calculate the repeating rows in the userid column. for example, I'm using this: User Reached = Sum(Single[follower_count]) + SUM(Single[following_count]) Thanks,
summation of currency not working
Hi! I have a table with AgreementLines all in local currency. Example: I have currencyRate table to be able to make a measure to calculate the currency of each row to NOK. I made a measure on my AgreementLine Table called "Total NOK": Total NOK = VAR _currency = MAX(AgreementLine[Cur] ) VAR _conversionRate = CALCULATE( MAX( CurrencyRate[Rate] ) ,CurrencyRate[TransactionCurrency] = _currency ) VAR _TotalInNok = SUM(AgreementLine[Total]) * _conversionRate RETURN _TotalInNok This works very well and the numbers are correct per row in my AgreementLine table. The problem is if I want to sum the field "Total NOK" in a table view or Card. TableView will end up like this: The correct sum for "Total NOK" would be: 39 432,53. I understand the logic, but what I want to achieve is to SUM each row of "Total NOK" which is already calculated. What is the best approach to deal with local currency and get this setup for my reports?
