Forum Discussion

anil2's avatar
anil2
Frequent Visitor
8 years ago

Create a measure based on existing measure

Is it possible to create a new measure based on existing measure?

 

I have a measure called "Utilization" that calculates ratio between two columns in the ssas model and I have subscription ID as column in the model. It is not possible to add my measure "Utilization" as visaul level fitler and select a condintion is greater than 90% in powerbi.

 

Now I would like to see distinct subscription ID's whose ratio is greater than 90% "Utilization".

 

Ca you suggest how it is feasible?

 

General Comment

6 Replies

  • SivaMani's avatar
    SivaMani
    Icon for Resident Rockstar rankResident Rockstar
    8 years ago

    anil2,

     

    You should be able to add measures as visual level filters.

    • anil2's avatar
      anil2
      Frequent Visitor
      8 years ago

      But i am not able to add measure as visual level filter. 

      • SivaMani's avatar
        SivaMani
        Icon for Resident Rockstar rankResident Rockstar
        8 years ago

        anil2,

         

        Which visual are you trying to add?

         

        Except for Slicer, you can add any field as a visual level filter.

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi anil2,

     

    It is not possible to apply a visual level filter for card visual.

     

    Now I would like to see distinct subscription ID's whose ratio is greater than 90% "Utilization".

     

    You could create a measure similar to:

    CountID =
CALCULATE (
    DISTINCTCOUNT ( tablename[subscriptionID] ),
    FILTER ( tablename, [Utilization] >= 0.9 )
)

    Regards,

    Yuliana Gu