Level of Detail Calcs to DAX

[jacobq]

Hi,

I have a report in Tableau and want to recreate it in PowerBI. However, I'm facing a couple of issues that need your help!

1. Maximum Value

The Maximum Key I get in tableau is different from what I get in Power BI. I checked the raw data, looks like the Tableau is getting the right number. Do you know why? How can I get the correct Max Key number in PowerBI? 

Tableau:

MAX([Ace Sla Track Key])

PowerBI:

Max Key = MAX(TABLE2[ACE_SLA_TRACK_KEY])

2. I need to create a Level of Detail calculation in PowerBI, but can't get it to work. Anyone can help?

I want to get the Count of each Appl Id that PXSUBSCRIPT contains "CaseQueued*" and within the same Createtime, only count the MAX ACE_SLA_TRACK_KEY

sample below:

Table 1 is "1 to many relationship" with Table 2 (by ACE_CR_APPL_KEY)

[Appl Id] is from Table1, all other columns are from Table2

Tableau Calculation:

Inflow=COUNT({ FIXED [Appl Id],[Pxsubscript],[Createdatetime]: MAX(IF CONTAINS([Pxsubscript],"CaseQueued") then [Ace Sla Track Key] end) } )

PowerBI Calculation THAT DOESN"T WORK

Inflow = CALCULATE(MAX(TABLE2[ACE_SLA_TRACK_KEY]), CONTAINS(TABLE2,[PXSUBSCRIPT],"CaseQueued"),

ALLEXCEPT(TABLE2,TABLE2[PXSUBSCRIPT],TABLE2[CREATEDATETIME]),

ALLEXCEPT(TABLE1,TABLE1[APPL_ID]) )

Any help is appreciated!

Thanks,

Jacob

[Anonymous]

It might very well be that you don't fully understand what the ALLEXCEPT function does. Here's something to help your understanding: Managing “all” functions in DAX: ALL, ALLSELECTED, ALLNOBLANKROW, ALLEXCEPT - SQLBI

Also, the amount of info you've given is not enough to troubleshoot. One needs to see the data and the model to even start thinking about troubleshooting.