Dashboard Creation

[vksk0338]

There is a concept of LOD in Tableau.What's the similar concept in PowerBI. I want to fix at certain level of Detail.

The Query used in Tableau is :- { fixed [Filedate] : COUNTD([Agreementid]) }.Whats the DAX Query in Power BI?

[Anonymous · Accepted solution]

Hi @vksk0338 ,

You can create a measure as below to get the same result in Power BI with the one( { fixed [Filedate] : COUNTD([Agreementid]) }) in Tableau.

Count Distinct Agreementid by Filedate =
CALCULATE (
    DISTINCTCOUNT ( 'Table'[Agreementid] ),
    ALLEXCEPT ( 'Table', 'Table'[Filedate] )
)

Best Regards