Include Lod of Tableau in Power BI

[Anonymous]

In Tableau We have Include LOD as below : 

{INCLUDE  [Region] : COUNTD([Categories])}

Need help to convert above calculation in PowerBI (Dax).

[Anonymous]

Hi, can you help me convert 

Tableau query -     % QA Checks Completed = sum({ INCLUDE [Sam Name],[Asset Class Name]: COUNT([defect_status])/[QA Inspections Required] }) to Powerbi DAX 

[jona4k]

I have some trouble getting a Tableau LOD statement in PowerBI. the Tableau expression is 
{fixed [column 1],[column 2],[column 3],[column 4],[column 5],[column 6]: [RP past retax]/[case count]}

I tried a DAX statement like this:
CALCULATE([RP past retax]/[case count],
ALLEXCEPT('table',[column 1],[column 2],[column 3],[column 4],[column 5],[column 6])
)

Sadly, the results do not match, any Idea what my missunderstanding about this is?

[v-jiascu-msft]

Hi @Anonymous,

Could you please mark the proper answers as solutions?

Best Regards,

Dale

[OwenAuger · Accepted solution]

@Anonymous

I would suggest the below DAX to replicate the behaviour of an INCLUDE LOD in DAX, assuming you are aggregating with SUM:

=
SUMX (
    VALUES ( 'table'[Region] ),
    CALCULATE ( DISTINCTCOUNT ( 'table'[Categories] ) )
)

Tableau's INCLUDE is very similar to an iterator in DAX applied to the distinct values of a particular column.

Regards,

Owen

[djraj2380]

Hi Owen, can you please share the DAX for below Tableau LOD with 2 columns. 

Example: {INCLUDE  [Region],[Category] : COUNTD([Categories])}

Thanks,

Jraj.

[OwenAuger]

Hi @djraj2380 

Assuming you want to sum the distinct count of Categories for each Region/Category combination, it would be something like this:

SUMX (
    SUMMARIZE (
        YourTable,
        YourTable[Region],
        YourTable[Category]
    ),
    CALCULATE ( DISTINCTCOUNT ( YourTable[Categories] ) )
)

Replace YourTable with appropriate table name(s).

Regards

[v-jiascu-msft]

Hi @Anonymous,

Try this formula as a measure, please.

Measure =
DISTINCTCOUNT ( 'table'[Categories] )

Then add the [Region] in a table visual with the Measure. The [Region] column is a context in the Power BI visuals. 

Best Regards,
Dale