topic Re: Need help on period measure in DAX Commands and Tips

Need help on period measure

VEERA3141 — Mon, 23 Oct 2023 03:28:45 GMT

Hi Team, could you please help on below senorio,

If TtValue<CummValue then show that partcular PValue else show MAX PValue

Greg_Deckler , OwenAuger ,

Thank you,

Veera

Re: Need help on period measure

123abc — Mon, 23 Oct 2023 05:10:14 GMT

It looks like you're trying to create a measure in Power BI that calculates a specific value based on a condition. In your scenario, you want to compare the value of TtValue to CummValue and based on that condition, display either the PValue or the maximum PValue.

You can achieve this using a DAX (Data Analysis Expressions) measure in Power BI. Here's a step-by-step guide on how to create such a measure:

Open your Power BI report.
Go to the "Model" view by clicking on the "Model" icon in the left-hand panel.
In the "Fields" pane, right-click on your table and select "New Measure." You can name your measure something like "Conditional PValue."
In the formula bar, you can use the following DAX formula:

Conditional PValue =
IF([TtValue] < [CummValue], [PValue], CALCULATE(MAX([PValue]), ALL('YourTableName')))

Replace 'YourTableName' with the name of the table where your data is located. This formula uses the IF function to check whether TtValue is less than CummValue. If it is, it returns PValue. Otherwise, it calculates the maximum PValue for all rows in the table.

Press Enter to create the measure.

Now you can use the "Conditional PValue" measure in your report visuals. When you place this measure in a visual, it will display the desired result based on your conditions.

Remember to replace 'YourTableName' with the actual name of the table in your Power BI data model. Make sure your column and table names match the names in your data source.

If you have further questions or encounter any issues, please provide more specific details about your data structure and I'd be happy to assist further.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

In case there is still a problem, please feel free and explain your issue in detail, It will be my pleasure to assist you in any way I can.

Re: Need help on period measure

FreemanZ — Mon, 23 Oct 2023 06:45:00 GMT

hi VEERA3141

not sure if i fully get you, try to add a calculated column like:

Expected2 = VAR MaxPValue = MAXX( FILTER( data, data[Category]= EARLIER(data[Category]) ), data[PValue] ) RETURN IF([TtValue]<[CummValue], [Pvalue], MaxPValue)

it worked like:

Re: Need help on period measure

VEERA3141 — Mon, 23 Oct 2023 06:57:48 GMT

Hi 123abc thanks for respond,

I am expecting the "Expected" Column in the image based on the condition, please find the below image for more details.

Expected = If TtValue<CummValue then show that partcular catogory PValue else show partcular catogory MAX PValue

Re: Need help on period measure

VEERA3141 — Mon, 23 Oct 2023 07:04:26 GMT

Hi FreemanZ thanks for respond,

I am expecting the "Expected" Column in the image based on the condition, please find the below image for more details.

Expected = If TtValue<CummValue then show that partcular catogory PValue else show partcular catogory MAX PValue

Hi @123abc thanks for respond,

I am expecting the "Expected" Column in the image based on the condition, please find the below image for more details.

Expected = If TtValue<CummValue then show that partcular catogory PValue else show partcular catogory MAX PValue

Re: Need help on period measure

FreemanZ — Mon, 23 Oct 2023 07:22:12 GMT

hi VEERA3141

the proposed solution is based on your expectataion:

"Expected = If TtValue<CummValue then show that partcular catogory PValue else show partcular catogory MAX PValue"

however, it comes with different result.

Could you also check the consistency of your description with your table?

For instance, for the row A, P1, TtValue > CummValue, so Max Pvalue of 9 should be returned, right?

Re: Need help on period measure

VEERA3141 — Mon, 23 Oct 2023 07:51:42 GMT

This is fine but how to get min values at catogory level by reusing the Expected 2 column FreemanZ

Re: Need help on period measure

FreemanZ — Mon, 23 Oct 2023 08:05:41 GMT

hi VEERA3141 , how would you use the min value?

Re: Need help on period measure

VEERA3141 — Mon, 23 Oct 2023 08:07:10 GMT

Got it calculate(min(expected 2), allecpect(table, cat))

Thank you