Count results of measure by other measure

[pardeepd84]

Hi,

I have created a meaure called calcmeasure as shown below:

CalcMeasure =

Var div = [Client OK] / [Count All 10]

RETURN

IF(div >= 0.9, "ok", "not")

I have created a matrix for this (see below), I now need to count how many records returned the result of "ok" and "not" for each provider from the "calcmeasure" measure, then turn this into a percentage.  

Please note calcmeasure is a measure based on other measures.   

I tried creating a measure using Countx and filter but that hasn't worked.  

Please advise how I could do this. 

[pardeepd84]

I am trying to filter the data by provider, however there are some cells within the provider column that are blank.  Is there a way to include (count) the data which are blank within this calculated column?

[Jihwan_Kim]

Hi, @pardeepd84 

Please provide your sample pbix file's link here.

I quite do not understand your question.

Have you tried what is the result of countrows(table) ? I think it also counts the blank rows

Please also describe your desired number with your sample.

[pardeepd84]

Hi,

How would I include if the provider ID was blank/the cell was empty?

[Jihwan_Kim]

Hi, @pardeepd84 

I am not sure if I understood your question correctly.

Do you want to filter out the blank cell of Provider column?

One way to do this is countrows (table) minus countblank(column)

Thank you.

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

[Jihwan_Kim]

Hi, @pardeepd84 

Please check the below picture and the sample pbix file's link down below.

I tried to create a similar sample pbix file.

All measures are in the sample pbix file, and the steps are numbered in front of each measure.

4 Counting ok =

VAR newtable =

FILTER (

SUMMARIZE ( 'Table', 'Table'[Provider], "calcmeasure", [3 CalcMeasure] ),

[calcmeasure] = "ok"

)

RETURN

COUNTROWS ( newtable )

https://www.dropbox.com/s/c5i058un8s749pv/pardeepd.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: https://www.linkedin.com/in/jihwankim1975/