Forum Discussion

abhiram342's avatar
abhiram342
Icon for Microsoft Employee rankMicrosoft Employee
2 years ago
Solved

Slice Data for column with command seperated values

Hi Team,   I have Fact and Dimension table and One of Column in Fact Table has comma seperated values and I want to slice data when I filter particular value from it. Please find below example   ...
"FILTER"
"Need Help"
Data Modelling
  • ERD's avatar
    ERD
    2 years ago

    abhiram342 , you can use this measure:

    AverageRunTime =
VAR appname = SELECTEDVALUE ( Applications[ApplicationName] )
VAR t =
    FILTER (
        ALL ( FactPipeline[ApplicationName] ),
        CONTAINSSTRING ( FactPipeline[ApplicationName], appname )
    )
RETURN
    CALCULATE ( AVERAGE ( FactPipeline[RunTime (Mins)] ), t )

     

ERD's avatar
ERD
Icon for Community Champion rankCommunity Champion
2 years ago

abhiram342 , you can use this measure:

AverageRunTime =
VAR appname = SELECTEDVALUE ( Applications[ApplicationName] )
VAR t =
    FILTER (
        ALL ( FactPipeline[ApplicationName] ),
        CONTAINSSTRING ( FactPipeline[ApplicationName], appname )
    )
RETURN
    CALCULATE ( AVERAGE ( FactPipeline[RunTime (Mins)] ), t )