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,

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