Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
FZU
Regular Visitor

Number of variation of a value

Hi,

I have a table like this

 

Production dateSerial NumberFinal Material
01/01/20191234601110
01/01/20191235601110
01/01/20191236601110
01/01/20191237601150
01/01/20191238601150
02/01/20191239601150
02/01/20191240601150

 

And Ineed to count the number of times the value "Final Material" changes during one day (so for example during 01/01/2019 it changed two times, during 02/01/2019 zero).

How can I do?

 

Thanks

 

 

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

Hi @FZU .

You can create a table visual with date and following measure formula to achieve your requirement:

Measure =
CALCULATE (
    COUNTROWS ( VALUES ( Table[Final Material] ) ),
    VALUES ( Table[Production date] )
)

Notice: above measure will auto summary current row contents level record and get distinct count of correspond materials.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

2 REPLIES 2
v-shex-msft
Community Support
Community Support

Hi @FZU .

You can create a table visual with date and following measure formula to achieve your requirement:

Measure =
CALCULATE (
    COUNTROWS ( VALUES ( Table[Final Material] ) ),
    VALUES ( Table[Production date] )
)

Notice: above measure will auto summary current row contents level record and get distinct count of correspond materials.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
jdbuchanan71
Super User
Super User

hello @FZU 

Changes = DISTINCTCOUNT ( Table[Final Material] ) -1

If you put this measure against a matrix with the [Production Date] on the rows it should give you what you are looking for.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.