Create a measure based on existing measure

[anil2]

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?

[v-yulgu-msft]

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

[SivaMani]

@anil2,

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

[anil2]

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

[SivaMani]

@anil2,

Which visual are you trying to add?

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

[anil2]

I am using Card visual.

[SivaMani]

I'm not seeing any issue. Kindly make sure that you're using the latest version of PBI Desktop.