Skip to main content

Posts

Featured

measure other measures

When you want to measure other measures, you need the iterative functions (a.k.a the “X” functions). In this case they wanted COUNTX(). I threw together an example PBIX with some random data. I have 4 data measurements each day (M1 – M4), each ranging from 1 – 99. I created a measure named GreaterThan50 as GreaterThan50 = IF(HASONEVALUE(Data[Date]) && HASONEVALUE(Data[Attribute]), IF (VALUES(Data[Value]) > 50, "Y", "N"), BLANK()) I then created a calculated column on the data table named GT, which stored the values of this measure. The data was unpivoted, so each row has a single measurement and a single date. That ensured that the measure wasn’t blank. I took this column and used the VALUES() function to create a new table, MeasureValues. MeasureValues = VALUES(Data[GT]) This gave me a table of all of the measure values of the data. In this case it was just “Y” and “N”, but it could have been any number of different values, depending on how they defined t…

Latest Posts

power bi sum of previous rows

The Q# Programming Language

How to get add-ins ready for Office 365

Develop a Provider-Hosted SharePoint App

Identifiers in TypeScript

O365 HIGH SPEED MIGRATION TECHNICAL SOLUTION