The count is just 1.
If I suppress Null on the calculated dimensions only the first one is returned.
AssetID AssetOwner Outlook Version Word Version Visio Version Count - 3 A1 James 2010 - - 1 A2 Fred 2013 - - 1 A3 Neil 2007 - -
if(match(SoftwareName, 'Outlook', 'Word', 'Visio'), SoftwareVersion)
still outputs multiple rows but instead of creating different columns as I wanted in the example, it puts them all under one column as its all done under one expression and has no way to show what software each version is for.
AssetID AssetOwner =if(match(SoftwareName, 'Outlook', 'Word', 'Visio'), SoftwareVersion) Count A1 James 2010 1 A1 James Standard2010 1 A2 Fred 2013 1 A2 Fred Professional2013 1 A3 Neil 2007 1 A3 Neil Standard2013 1
I will attach a QVW with example data tables aswell.