How to make my P&L report table display category ?

[admin11]

Hi All

I have below PBI file from @VijayP  working fine , it can display category field :-

https://www.dropbox.com/s/8fepay89fpt0sl6/P%26L%20Vijay%20ver03%20TDS%20working%20COPY_9.pbix?dl=0

Above link is the PBI file.

I try to duplicate the above PBI file by myself but it cannot display Category field  :-

https://www.dropbox.com/s/6mwb6dj3bymwd0p/P%26L%20Vijay%20ver04%20TDS%20not%20working%20COPY%209.pbi...

Above link is the PBI file :-

Can some one share where go wrong ?

Paul 

[nandic · Accepted solution]

Hi @admin11 ,

This measure is not the same in the files.

In original file:

Total Profit_ =

VAR Revenue = CALCULATE(SUM(GL_TI[C/D]),Fin_Category[Type]="Revenue")*-1

VAR Expenses = CALCULATE(SUM(GL_TI[C/D]),Fin_Category[Type]="Expenses")*-1

Return

Revenue+Expenses

When i paste same logic to new file, it displays categories.
Make sure all measure have same calculations.

Regards,
Nemanja Andic

[nandic · Accepted solution]

Hi @admin11 ,

This measure is not the same in the files.

In original file:

Total Profit_ =

VAR Revenue = CALCULATE(SUM(GL_TI[C/D]),Fin_Category[Type]="Revenue")*-1

VAR Expenses = CALCULATE(SUM(GL_TI[C/D]),Fin_Category[Type]="Expenses")*-1

Return

Revenue+Expenses

When i paste same logic to new file, it displays categories.
Make sure all measure have same calculations.

Regards,
Nemanja Andic

[admin11]

@nandic 

Thank you for sharing ,  wow you are very smart. Can you pls share how can you spot the error in just few minute ?

org :-

Total Profit_ =
VAR Revenue = CALCULATE(SUM(GL_TI[C/D]),Fin_Category[Type]="Revenue")*-1
VAR Expenses = CALCULATE(SUM(GL_TI[C/D]),Fin_Category[Type]="Expenses")*-1
Return
Revenue+Expenses

not working :-
Total Profit_2 =
VAR Revenue = CALCULATE(SUM(GL_TI[C/D]),Fin_Category[Category]="Revenue")*-1
VAR Expenses = CALCULATE(SUM(GL_TI[C/D]),Fin_Category[Category]="Expenses")*-1
Return
Revenue+Expenses

 Can you share with me please.

Paul

[nandic · Accepted solution]

Hi Paul,
If the structure of the files is the same, then the reason must be calculated columns or measures.
In most cases measures are the ones that "carry" the logic and they define filters and whether something should be displayed or not.
So main focus was on comparing measures. Luckily, there weren't too many measures so it took couple of minutes to check.

Furthermore, if there were more measures and they have lots of lines, here is a nice online tool to quickly compare queries / code: https://www.diffchecker.com/diff 

Regards,
Nemanja Andic

[admin11]

@nandic 

Okay Thank you very much , need to understand the data model.