topic Re: HOW TO SHOW THAT YEAR WISE CHOHART ANALYSIS in DAX Commands and Tips

HOW TO SHOW THAT YEAR WISE CHOHART ANALYSIS

Anonymous — Tue, 26 Jul 2022 11:32:42 GMT

Hi All,

I am Struggling with some DAX in the cohort analysis Report. which means customer count and percentage of these things it will be showing on dynamic only. because I can't able to create year-wise cohort analysis data. I tried but I didn't get that. but I got only month-wise data. if anyone knows about this one please sort me out. here I have attached what I want to show.

Advance Thanks

Re: HOW TO SHOW THAT YEAR WISE CHOHART ANALYSIS

tamerj1 — Tue, 26 Jul 2022 11:41:43 GMT

Hi Anonymous
You can use two disconnected filter tables each containing the values of the years. The rest can be handled by DAX. Example
DIVIDE (
CALCULATE ( SUM ( Table1[Value] ), YEAR ( Table1[Date] ) = SELECTEDVALUE ( FilteTable1[Year] ) ),
CALCULATE ( SUM ( Table1[Value] ), YEAR ( Table1[Date] ) = SELECTEDVALUE ( FilteTable2[Year] ) )
)

Re: HOW TO SHOW THAT YEAR WISE CHOHART ANALYSIS

Anonymous — Wed, 27 Jul 2022 09:25:23 GMT

HI tamerj1

Can you send any sample pbix files? because I got it more than 100% in that matrix visual that's y am asking and after that, we are showing distinct customer count percentage and customer Count also in this report. Here I attached the screenshot as well.

Re: HOW TO SHOW THAT YEAR WISE CHOHART ANALYSIS

tamerj1 — Wed, 27 Jul 2022 11:27:43 GMT

Hi Anonymous

sorry I was not on my computer for past 5 hours. The numbers are correct but seems that you want limit the calculation so as to blank out the upper diagonal part of the matrix. I will try to create a sample file probably this evening

Re: HOW TO SHOW THAT YEAR WISE CHOHART ANALYSIS

tamerj1 — Wed, 27 Jul 2022 12:36:22 GMT

Anonymous
Also can you please share a copy/paste of the row data?

Re: HOW TO SHOW THAT YEAR WISE CHOHART ANALYSIS

bhavnachalise15 — Mon, 01 Apr 2024 13:22:01 GMT

Hi is it possibl to share how have you created this. Because I'm able to get only MOM Data not YOY.