topic Re: the DAX i have written is giving Results are 3 for all the categories rows in DAX Commands and Tips

the DAX i have written is giving Results are 3 for all the categories rows

yeshwanthkumar2 — Fri, 22 Nov 2024 07:38:57 GMT

here is Dax
MINX(

FILTER(

ALLSELECTED(TABLBLENAME),
[CUMULATIVEPRS] >= [THRESOLD 80] ),

'TABLENAME'[CYCLETIME] )

Here i have to get the results as per percentile 80 based on the cycle time where i am selecting all fields under CGA column the results are giving as 3 for all the rows, however if iselec single field results are ginving correct.

Please assist me

Re: the DAX i have written is giving Results are 3 for all the categories rows

FreemanZ — Fri, 22 Nov 2024 07:42:07 GMT

hi yeshwanthkumar2 ,

try to leave out ALLSELECTED,

or how are [CUMULATIVEPRS] and [THRESOLD 80] defined?

Re: the DAX i have written is giving Results are 3 for all the categories rows

yeshwanthkumar2 — Fri, 22 Nov 2024 07:46:45 GMT

itis defined as measures in the table

Re: the DAX i have written is giving Results are 3 for all the categories rows

FreemanZ — Fri, 22 Nov 2024 07:49:07 GMT

with what code?

Re: the DAX i have written is giving Results are 3 for all the categories rows

yeshwanthkumar2 — Fri, 22 Nov 2024 07:56:32 GMT

Cumilative Prs code is
Calculate(
Distinctcount(tablename[requesitionID]),
Filter(
Allselected(Tablename),
'Tablename' [cycletime] <= MAX ('Tablename'[cycletime]))

For Thresold 80 code is
[TotalPRs]* 0.80

Re: the DAX i have written is giving Results are 3 for all the categories rows

FreemanZ — Fri, 22 Nov 2024 08:22:39 GMT

what code for [TotalPRs]?

Re: the DAX i have written is giving Results are 3 for all the categories rows

yeshwanthkumar2 — Fri, 22 Nov 2024 08:28:50 GMT

Totaal Prs=
Calculate(
Distinctcount('tablename'[requisition ID]),
Allselected('Tablename') )

Re: the DAX i have written is giving Results are 3 for all the categories rows

yeshwanthkumar2 — Fri, 22 Nov 2024 09:53:33 GMT

Any update please

Re: the DAX i have written is giving Results are 3 for all the categories rows

Kedar_Pande — Fri, 22 Nov 2024 10:44:16 GMT

yeshwanthkumar2

Try modifying the measure

PercentileResult =
MINX(
FILTER(
ALLSELECTED('TABLENAME'[CGA], 'TABLENAME'[CYCLETIME]), 
[CUMULATIVEPRS] >= [THRESOLD 80]
),
'TABLENAME'[CYCLETIME]
)

💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn

Re: the DAX i have written is giving Results are 3 for all the categories rows

yeshwanthkumar2 — Fri, 22 Nov 2024 11:42:57 GMT

Still results are same as 3 for all the rows. I think it is stopping somewhere on rows filtering. Kindly advise

Re: the DAX i have written is giving Results are 3 for all the categories rows

Anonymous — Mon, 25 Nov 2024 02:05:26 GMT

Hi yeshwanthkumar2

Please provide sample data that would completely cover your problem and describe what you have done currently and what results you expect. If you can provide pbix files that would be great. (Please remove privacy information)

How to Get Your Question Answered Quickly - Microsoft Fabric Community

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.