Forum Discussion
Solved
Dashboard Creation
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?
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
1 Reply
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