Migration of Tableau LOD to Power bi

[Anonymous]

Hi All,

i need your help to build Dax using below Tableau Lod

% Doc count = [count Doc] / TOTAL([count Doc])

where "Count Doc" is distinct count of "docno"

Thanks in advance.

[Samarth_18]

Hi @Anonymous ,

It would help us to give answer more specifically if you could share some sample data with required output.

You can try below code:-

% Doc count =
VAR distinct_count =
    CALCULATE ( DISTINCTCOUNT ( [count Doc] ) )
VAR total_count =
    CALCULATE ( COUNT ( [count Doc] ) )
RETURN
    DIVIDE ( distinct_count, total_count )

Thanks,

Samarth