Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Count Of Values in New Measure Field from Two Tables

Hello, I need to create a New Measure filed to list count of No error Projects with Monthly basis. I am having two Table, 1. Version Table 2. QC Error Table. Schema for Version Table is:      [Id...
Measures
power bi
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi all,

anyone having idea to resolve the above issue.

 

i tried this in PowerBI New Table command.

Table 2 = GENERATEALL(SUMMARIZE('Version Table','Version Table'[Project ID at SMA],'Version Table'[Id]),SUMMARIZE('QC Errors','QC Errors'[Version],"TestColumn",COUNTX('QC Errors',Value('QC Errors'[Version]) = 'Version Table'[Id])))

But i am getting following error in expression.

can anybody help me to resolve this.

Thanks

 

v-evelk's avatar
v-evelk
Microsoft Employee
6 years ago

Hi guys,

 

Unfortunately, DAX is out of my expertise, at least for a while.

However, you could ask in more suitable threads as that one and another one.

 

Kind Regards,

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
[email protected]