Forum Discussion

vksk0338's avatar
vksk0338
New Member
2 years ago
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]) }.Wha...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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