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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
ronbermudez
Helper I
Helper I

Count of value for a Measure

Is it even possible to get the count for the DAX measure below?

Delta T100 - T0 =
CALCULATE(MIN(T0_T100_Delta_Distibution[value]) , T0_T100_Delta_Distibution[Folder1] = "t100")
-
CALCULATE(MIN(T0_T100_Delta_Distibution[value]) , T0_T100_Delta_Distibution[Folder1] = "t0")


I've been trying for weeks on my own.

First, I need a measure to show each unique value for the Delta column, Delta T100-T0.
Second, I need to show the count of occurrences for each unique value.

The expected table and visual must be derived from the table contained in the pbix.  Attached at the bottom.
Expected Table

Delta T100-T0: Unique ValuesCount of Unique Values

1

62

2

1
101


Expected Visual   ( I mocked this visual)

ronbermudez_1-1682212943283.png

I loaded the table contained in .pbix in the link below:

https://drive.google.com/file/d/1Tl0u3OIa3Hn2iGBif4dZfYEMcY9vJrb5/view?usp=share_link

1 ACCEPTED SOLUTION

Hey Ron,

 

See changed pbix here. Maybe there's a different way but I essentially created a summary table of your data (change it or add columns as needed) so I could use the deltas from that summary table as the min and max values of another table (a parameter table). That parameter table was used to calculate your counts.


----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





View solution in original post

5 REPLIES 5
ronbermudez
Helper I
Helper I

Hi  @Wilson_ 
Thanks.  I need your help!

In practice, T0 represents data before testing begins.  Subsequent Tn data (T100, T125, T150), will represent data after hours of conditioning.  Tn = 100 hours, 125 hours, 150 hours.  The device is tested at each Tn interval.

I want to compare the delta from T0 vs T100 and T125 and T150.  Then see the frequency distribution of the deltas between T100 vs T125 vs T150 for every single delta value.

The real data table will be over 50K rows, and as much as 500K rows.  Depending on the sample size.

The expected deltas are expected to change as the conditioning hours lengthen.
When the delta frquency distribitions are compared in a single visual we should be able to see that trend.

Wilson_
Super User
Super User

Hello Ron,

 

I'm happy to help.

 

However, I'm struggling to figure out what you're trying to accomplish, even looking at the pbix and your expected visual. Can you maybe rephrase and/or use a smaller table of data to illustrate your expected results? What is the Delta T100-T0 measure supposed to calculate, in words? The measure itself doesn't make sense to me.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





@Wilson_ 
In the screen capture below, I've highlighted, in green, three different measures that calculate the same thing.
Which is the difference between column t100 and t0.

I'm trying to get the count of occurances for each unique value in the delta columns.  Highlighted in green
In other words, I'm trying to get the count of the measure.  For each and every delta value in the column.  Just one of the delta measures.  Not all the delta measures.

I've been trying everything: count, countx, counta.   Unsuccessfully.

I'm sure it can be done.  I'm just not that much of an expert at Power BI DAX to figure it out myself.

ronbermudez_0-1682374356606.png


I've loaded the table here:
https://drive.google.com/file/d/17bE1vnuyFIF_57ibm4f4hjt2lKaundP_/view?usp=share_link

 

Hey Ron,

 

See changed pbix here. Maybe there's a different way but I essentially created a summary table of your data (change it or add columns as needed) so I could use the deltas from that summary table as the min and max values of another table (a parameter table). That parameter table was used to calculate your counts.


----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





@Wilson_ 

Thank you! I've been away from any PBI development that last month.  Now, it's due.  Oh boy.
I'll check it out.  Thanks for your time again....

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

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

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.