topic Re: Calculation in DAX measure returing all the rows. in Developer

Calculation in DAX measure returing all the rows.

Anonymous — Wed, 22 Jul 2020 15:00:59 GMT

Hi Everyone,

I created a measure using below query. Logic wise it is correct but the only thing I am facing right now is that It is returning all the rows from the table. What I observe is I am getting this output because in Var R1 and R2 I am doing some calculation. As you can see below i am adding 1 and also multiplying it with 10. This is applying to each row in the table. Can someone please let me know how should I write R1 and R2.

I also have a date slicer in the report page. where I am selecting only 1 date.

IndexBaseValue =
Var Mindate = CALCULATE(MIN(IndexFundNAV[Date]),ALL(IndexFundNAV[Date]))
Var Maxdate = CALCULATE(MAX(IndexFundNAV[Date]))
Var Currentdate = IF(Maxdate<Mindate,Mindate,Maxdate)
Var Diffdays = DATEDIFF(Mindate,Currentdate,DAY)
Var R1 = CALCULATE(10*(1+[RITD%]))
Var R2 = CALCULATE((10*(1+[RITD%]))^(Diffdays/365))

Var Result = if (Diffdays<365,R1,R2)

Return
Result

Example for desired output:

Date IndexName IndexBaseValue

28-Sep-19 ABC 8.9

Currently getting:

Date IndexName IndexBaseValue

28-Sep-19 ABC 10

28-Sep-19 ABC 8.9

Re: Calculation in DAX measure returing all the rows.

Greg_Deckler — Wed, 22 Jul 2020 15:57:28 GMT

@Anonymous - A little difficult to tell what is going on, sample source data might help.

Check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

Re: Calculation in DAX measure returing all the rows.

Anonymous — Thu, 23 Jul 2020 07:47:25 GMT

Thanks @Greg_Deckler for your reply. I will check the links which you have shared. However my issue got resolved. There was some table relatioship issue was there because of that the measure not returing the correct answer.