Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only

View My Drafts

  • 1.  Cumulative calculation and use relationship

    Posted 14 days ago
    Hello,
    I have an issue getting the cumulative data using the "use relationship" function

    I have this model

    This code works fine
    CountofDocSent = CALCULATE(DISTINCTCOUNT(Data Table[Document No]),USERELATIONSHIP(DateTable[Date],Data Table[Date Sent]))
    But this one is not getting any data

    ComulDocSent = CALCULATE(
                        DISTINCTCOUNT(Data Table[Date Sent]),
                        USERELATIONSHIP(Data Table[Date Sent],DateTable[Date]),
                        Filter(ALLSELECTED(Data Table),
                        Data Table[Date Sent]<=MAX(DateTable[Date])))​​


    ------------------------------
    Armia Gab
    ------------------------------


  • 2.  RE: Cumulative calculation and use relationship

    Posted 9 days ago
    Tente
    ComulDocSent =
CALCULATE (
    [CountofDocSent],
    FILTER (
        ALLSELECTED ( DateTable[Date] ),
        [Date] <= MAX ( DateTable[Date] )
    )
)​


    ------------------------------
    Vilmar Santos
    ------------------------------

    Original Message