Forum Discussion

Razwan's avatar
Razwan
Helper I
5 years ago
Solved

Display specific data in matrix

Hello, I am using the following simple data model: The FactTable has the following structure: The Calendar table contains dates from 2018 until 2021. In PowerBi canvas I have created ...
Need Help
  • v-deddai1-msft's avatar
    v-deddai1-msft
    5 years ago

    Hi Razwan ,

     

    Would you please try to use the following measure:

     

    # Lost =
COUNTX (
    FILTER (
        SUMMARIZE (
            FactTable,
            FactTable[Customer Name],
            'Calendar'[Year],
            "_Total", [Total],
            "_TotalLY", [Total Ly]
        ),
        [Total] = 0
            && [Total LY] <> 0
    ),
    FactTable[Customer Name]
)

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    Best Regards,

    Dedmon Dai