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
Anonymous
Not applicable

Calculate Standard deviation for each period column in matrix table

Hi Experts

 

See attached sample data in the form of a matrix table i want to calculate the Std.dev for each period Month 0, Month 1, Month 2 and show the result in a standard card visual below each column.

 

Totally stuck.

https://www.dropbox.com/s/0bdlo5sjw9soi7w/FADSampleData%20%282%29.pbix?dl=0 

 

1 ACCEPTED SOLUTION

@Anonymous 

You can drag and drop the YearMonth filed to the Visual filter of the card and set the filter

Fowmy_0-1627201510504.png

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

7 REPLIES 7
Fowmy
Super User
Super User

@Anonymous 

You can create the following  calculation and set the month filter in the card visual filter as follows

STD Dev Month = STDEV.S(Llo_FAD_Data[Result])

Fowmy_0-1627200576404.png

 



Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Anonymous
Not applicable

Alternative - could we get the Stand dev of a measure in Power BI - Assume my measure was [Month 0.]

Anonymous
Not applicable

Hi Fowmy, Its close but not right i need to take into consideration the Year_month period. Apologies i totally forgot to mention this....

@Anonymous 

You can drag and drop the YearMonth filed to the Visual filter of the card and set the filter

Fowmy_0-1627201510504.png

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Anonymous
Not applicable

Hi Fowny
this is the real tricky one, https://community.powerbi.com/t5/Desktop/Standard-Deviation-of-multiple-values-same-dates/m-p/197750...

 

could you kindly have alook. please

Fowmy
Super User
Super User

@Anonymous 

Can you accept the solution for the following related question if it works for you?

https://community.powerbi.com/t5/Desktop/Tricky-measure-to-add-columns-in-matrix-table/m-p/1977280

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Anonymous
Not applicable

Morning Fowmy - i just did the solution was prefect 100%. Thank you

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.