Forum Discussion

Hussain's avatar
Hussain
Icon for Helper I rankHelper I
5 years ago
Solved

Measure to filter columns

Hi   I have a database table with a column named multimedia type which has 3 values - Video,Image,Other. I want to create a Power BI Table for the category Video only. I want to display the Multi...
Need Help
  • AllisonKennedy's avatar
    AllisonKennedy
    5 years ago

    If you just want number of rows, use COUNTROWS: 

     

    Videos =COUNTROWS(FILTER(VaultAssets,VaultAssets[VideoImageOther]="Videos"))

     

    Otherwise, to replace blank with zero, try: 

     

    Video Length(Secs):=SUMX(FILTER(VaultAssets,VaultAssets[VideoImageOther]="Videos"),IF(ISBLANK(VaultAssets[FileLength]), 0, VaultAssets[FileLength]))

AllisonKennedy's avatar
AllisonKennedy
Icon for Community Champion rankCommunity Champion
5 years ago

If you just want number of rows, use COUNTROWS: 

 

Videos =COUNTROWS(FILTER(VaultAssets,VaultAssets[VideoImageOther]="Videos"))

 

Otherwise, to replace blank with zero, try: 

 

Video Length(Secs):=SUMX(FILTER(VaultAssets,VaultAssets[VideoImageOther]="Videos"),IF(ISBLANK(VaultAssets[FileLength]), 0, VaultAssets[FileLength]))