topic Re: Create New Measure count of text with a conditional denominator in DAX Commands and Tips

Create New Measure count of text with a conditional denominator

EvalUncovered — Thu, 26 Sep 2024 18:50:26 GMT

I am trying to get a precentage to put in a KPI card but am having trouble.

I have a data set with a flag which indicates if a certain observation is a certain type of corporate priority. I want to know what percentage of these fall into that type of priority but only for a particulat product line using a quick measure.

Basically, my data looks like this:

ProductSku	ProductLine	Type	IsPriority
1	Tech	toys	Y
2	Tech	IT	N
3	Farm	Tractors	N
4	Tech	entertainment	N

I have tried a few different things but can't get it to work.

% priority =

COUNTROWS(

FILTER(

SUMMARIZE (

'Table',

'Table'[IsPriority],

"Y" ),

[ProductLine] = "Tech" && ISBLANK([ProductLine]) = FALSE

)

Any suggestions? This should basiclly just be looking at line 1, 2 and 4 in the case of the fake data for the demonator and observation 1 for the numerator. Thank you!

Re: Create New Measure count of text with a conditional denominator

Jihwan_Kim — Thu, 26 Sep 2024 19:03:05 GMT

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

% priority = VAR _t = FILTER ( 'Table', 'Table'[ProductLine] = "Tech" ) RETURN DIVIDE ( COUNTROWS ( FILTER ( _t, 'Table'[IsPriority] = "Y" ) ), COUNTROWS ( _t ) )

Re: Create New Measure count of text with a conditional denominator

EvalUncovered — Thu, 26 Sep 2024 20:37:29 GMT

thank you so much!