Total of SELECTEDVALUE

[giuliapiazza94]

Hi guys,

I have 2 tables like theese and I want to repeat the credit limit for each date. I've tried to use SELECTEDVALUE(credit limit) and it works but there isn't the total 14700.

can you help me please?

thank you all 😁

[Whitewater100 · Accepted solution]

Hello:

I had a very similiar reply to the same type of question. If you look at the Dates and Limit Table on the attached link you will see the CL by date in the dates table(you have to scroll down as the limit dates start mid-year. The limit table is an example how to format this SCD. https://drive.google.com/file/d/1dziPjkIk2ub9vofzGUTu8krkl58aKZ7K/view?usp=sharing I hope this helps you.

[giuliapiazza94]

if i use ISINSCOPE it works like

but the total is wrong because it sum all values, instead It should sum values one time.

Ideas to solve the problem?

[v-easonf-msft]

Hi, @giuliapiazza94 

Please add a new measure like below:

Measure = SUMX(VALUES('Table A'[Customer]),[Measure_credit limit])

If it doesn't work, please share your sample pbix for further research.

Best Regards,
Community Support Team _ Eason

[Whitewater100]

Hi:

If you want to share a file that represents your issue, that would be helpful.

Without knowing much now, you can try a measure like CLOSINGBALANCEMONTH or CLOSINGBALANCEYEAR.

First you'd need a date table,marked as such and have it relate to the appropriate tables. Here I'm calling it DATES and the first column name is "Date".

Then you can get your total CL,

e.g. CredLimit Total = SUM(Table[CreditLimit])

Then CrdLim EOY =  CLOSINGBALANCEYEAR([CredLimit Total], Dates[Date])

Easier to solve with the real data though. Hope this helps!

[amitchandak]

@giuliapiazza94 , Crossjoin or generate

crossjoin(Tablea, Tableb)