Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only
  • 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
    ------------------------------