Forum Discussion
Solved
Need help with creating filtered column
Hi all, new to Power BI and I'm really stuck. We collect telemetry data from our users periodically. It comes in as key value pairs and we insert it into a DB basically like so: CUSTOMER_ID INSERTI...
Hi AKB
with your data looking like this
you can create a measure like this:
NumRuleMaxInsertId = VAR CustID = MAX( Table1[Cust] ) VAR InsID = MAX( Table1[Ins] ) RETURN CALCULATE( COUNTROWS( Table1 ),
Table1[Cust] = CustID,
Table1[Ins] = InsID,
Table1[Key] = "RULE"
)HTH,
Frank
Hi AKB
with your data looking like this
you can create a measure like this:
NumRuleMaxInsertId = VAR CustID = MAX( Table1[Cust] ) VAR InsID = MAX( Table1[Ins] ) RETURN CALCULATE( COUNTROWS( Table1 ),
Table1[Cust] = CustID,
Table1[Ins] = InsID,
Table1[Key] = "RULE"
)
HTH,
Frank