cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Measure for Dividing the No of Suppliers in 2016 by 2017

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III
Super User III

Re: Measure for Dividing the No of Suppliers in 2016 by 2017

@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
Regards,
Zubair


View solution in original post

2 REPLIES 2
Highlighted
Super User III
Super User III

Re: Measure for Dividing the No of Suppliers in 2016 by 2017

@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
Regards,
Zubair


View solution in original post

Highlighted
Helper I
Helper I

Re: Measure for Dividing the No of Suppliers in 2016 by 2017

Thnak you

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors