Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Need help with power bi

  # of Projects in Progress = CALCULATE ( COUNTROWS ( DataDump1 ), FILTER ( DataDump1, DataDump1[Vendor] = EARLIER ( DataDump1[Vendor] ) ), FILTER ( DataDump1, DataDump1[...
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    8 years ago

    Hi Anonymous

     

    You may try below DAX:

    Column  =
IF (
    DataDump1[POWord Count] > 0
        && DataDump1[Sent To Accounting Date].[Date] <> BLANK (),
    COUNTROWS (
        FILTER (
            DataDump1,
            DataDump1[Vendor] = EARLIER ( DataDump1[Vendor] )
                && DataDump1[Subject Matter] = EARLIER ( DataDump1[Subject Matter] )
        )
    )
)

    Regards,

    Cherie

ChrisMendoza's avatar
ChrisMendoza
Icon for Resident Rockstar rankResident Rockstar
8 years ago

Anonymous,

 

Not an answer for your issue but, rather a suggestion to help get your solution answered sooner rather than later:

 

Use the Insert Code feature for your post and format your code block so it can be more easily read like:

 

# of Projects in Progress =
CALCULATE (
    COUNTROWS ( DataDump1 ),
    FILTER ( DataDump1, DataDump1[Vendor] = EARLIER ( DataDump1[Vendor] ) ),
    FILTER (
        DataDump1,
        DataDump1[Subject Matter] = EARLIER ( DataDump1[Subject Matter] )
    ),
    AND (
        FILTER ( DataDump1, DataDump1[Sent To Accounting Date].[Date] = BLANK () ),
        FILTER ( DataDump1, DataDump1[POWord Count] > 0 )
    )
)

I use http://www.daxformatter.com/ for formatting.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Thank you for the advice! ChrisMendoza