Show only the invoices that have more than one code

[Anonymous]

Hi community,

I am struggling with something that is probably pretty simple, I just cant make it work. My data looks like below in a matrix layout:

I want to show only the invoices that have more than one servicecode against them. So, the red crossed ones shouldn't appear in the matrix.

I tried grouping in a dax formula, but doesnt work. My sample pbi file is attached:

https://1drv.ms/u/s!Ag919_pO_UKrgQG4x8WBL51QJYz9?e=erDEu4

Many thanks in advance,

Meena

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

Create a measure and add it to the visual level filter

Measure =
CALCULATE (
    DISTINCTCOUNT ( 'Table'[Service code] ),
    FILTER (
        ALLSELECTED ( 'Table' ),
        'Table'[Servicedate]
            = MAX ( 'Table'[Servicedate] )
            && 'Table'[GP Code]
                = MAX ( 'Table'[GP Code] )
            && 'Table'[invoiceid]
                = MAX ( 'Table'[invoiceid] )
    )
)

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

Check solution at

https://www.dropbox.com/s/rl1ks43ydzirtao/Test_invoices.pbix?dl=0

New amount = CALCULATE(SUM('Table'[Amount]),VALUES('Table'[Servicedate]),FILTER('Table',[Measure]>1))
Measure = CALCULATE(DISTINCTCOUNT('Table'[Service code]),ALLEXCEPT('Table','Table'[GP Code],'Table'[Servicedate]))

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Proud to be a Datanaut Connect on Linkedin

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

Create a measure and add it to the visual level filter

Measure =
CALCULATE (
    DISTINCTCOUNT ( 'Table'[Service code] ),
    FILTER (
        ALLSELECTED ( 'Table' ),
        'Table'[Servicedate]
            = MAX ( 'Table'[Servicedate] )
            && 'Table'[GP Code]
                = MAX ( 'Table'[GP Code] )
            && 'Table'[invoiceid]
                = MAX ( 'Table'[invoiceid] )
    )
)

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.