For only one FY Data is showing incorrect , for rest all data is correct

[Sajid02]

Hi Folks, 

I am facing an issue with a data set . The data are in from of period code, Financial year , Attribute and Vol in the database. 

Ref:-

Now i have created , Financial year columns to get data attribute wise. But with the financial year 2021/22 , data is showning incorrect for summary visual , rest individual visuals has correct data .

Ref:-

Instead , the value in first visual should be shown line - 63339  

Like it should be the sum of both below visual , one can check with other financial year .

DAX used to get Financial year Data -

2021/22 = IF('ODI Report'[Actual Financial Year] = "2021/2022" , 'ODI Report'[Vol] , 0)

And if i am using in particular this Dax for fy 2021/22 ONLY -

Orginal :- 2021/22 = IF('ODI Report'[Actual Financial Year] = "2021/2022" && 'ODI Report'[CurrMonth] = TRUE() , 'ODI Report'[Vol] , 0 ) THEN VISUAL CHANGES LIKE THIS -

Except first visual , rest two values having correct value . First should be the sum of both bottom two visuals. 

Please help on this , how to correct this ?

Thanks !

[amitchandak]

@Sajid02 , Try meausre like

Calculate(Sum('ODI Report'[Unique Customer]) ,Filter('ODI Report','ODI Report' [Actual Financial Year] = "2021/2022"))

Or measure like this with Year table 

Calculate(Sum('ODI Report'[Unique Customer]) ,Filter('Year','Year' [Actual Financial Year] = "2021/2022"))

Calculate(Sum('ODI Report'[Unique Customer]) ,Filter('Year','Year' [Actual Financial Year] = max('Year' [Actual Financial Year] )))

[Sajid02]

Hi Amit , 

Tried this but not  working as Unique Customer is not taking up as measure and showing error as with calculate and sum function , unique customer is not filtering out

[amitchandak]

@Sajid02 ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Sajid02 · Accepted solution]

Hi Amit , 

It is solved now . I found it just a filter issue in visual one. There were no filters applied and due to this it is taking all data . Now , after applying filter on not unique customer , data is showing all correct . 

Thanks for the help , Man !

[v-chenwuz-msft]

Hi @Sajid02 ,

Glad your problem is solved, please mark it as a solution so that more people can see it.

Best Regards

Community Support Team _ chenwu zhu