Measure for Dividing the No of Suppliers in 2016 by 2017

[mahra-in]

Hi I needa Measure for Dividing the Distinct No of Suppliers in 2016 by 2017

Date           Supplier

5-5-2016    ABB

5-6-2016    Siemens

7-7-2016    ABB

9-8-2016    GE

8-9-2016    ABB

1-1-2017    RTI

1-4-2017    ABB

2-3-2017    GE

6-8-2017    Siemens

7-8-2017    GE

In the above No of Distinct Suppliers in 2016 is 3 &

No of Distinct Suppliers in 2017 is 4.

Need measure to give soultion for the percentage of increase/decrease of supplier in 2017 compared with 2016

[Zubair_Muhammad · Accepted solution]

@mahra-in

Try this MEASURE. Format it as %age

Measure =
DIVIDE (
    CALCULATE (
        DISTINCTCOUNT ( TableName[Supplier] ),
        YEAR ( TableName[Date] ) = 2017
    ),
    CALCULATE (
        DISTINCTCOUNT ( TableName[Supplier] ),
        YEAR ( TableName[Date] ) = 2016
    )
)
    - 1

[mahra-in]

Thnak you