Need help on explanation

[axaeffect]

Hello everyone,
Can someone help me to understand what is the logic behind my measures.
I’ve uploaded my PBIX as attached.

So basically I have this measure (which I have on this forum as well ):
Aging =
CALCULATE(
DATEDIFF(
SELECTEDVALUE( FactInternetSales[DueDate] ),
[SelectedDate],
DAY
),
ALLSELECTED(
DimDate[FullDateAlternateKey]
)
)

This is to calculate My transaction table’s date (DueDate) to the date in the slicer. For this measure, I just want to confirm, that the phrase " SELECTEDVALUE( FactInternetSales[DueDate] )," is meaning for the current row when I put my transaction to a table, am I correct ?

My main confusion is how to create a measure that “synchronize” with the current row display on my table. So what I want is to create a measure that only specify that the value of the 1st measure is either “small” or “big”

Since I create the measure, like this :
AgingCategory =
VAR SO = SELECTEDVALUE(FactInternetSales[SalesOrderNumber])
RETURN CALCULATE(
IF([Aging with Total]<=1,“small”,“big”),
FactInternetSales[SalesOrderNumber] = SO
)
When I put that in my table, it looks like it display all of my data in transactions instead the correct previous rows.

So basically, in that PBIX, my transaction table is FactInternetSales. and already correct measure of “Age”, and I’m added another (which not work) called AgingCategory.into the Table Visual Studio.Testing_AgingAdventureWorksDW_Import - solution2.pbix (737.8 KB)

I’m sorry, but I a beginner in DAX, and still in learning phase.

Thanks

[BrianJ]

@axaeffect,

I’m working on a response to your questions raised in the thread below that should also answer all your questions here. Should have something back to you later this evening.

• Brian

Capture date from Date Slicer

Hi Brian, This is great. Thanks so much for your assistance and help. It took me sometime to understand the measure to be honest. Do you mind to explain a bit, while in CALCULATETABLE --> CALCULATETABLE( ADDCOLUMNS( FactInternetSales, “AgingVirt”, [Aging] ), ALLSELECTED( DimDate[FullDateAlternateKey] ) ) Is it this virtual table will only contain the date in current row? Secondly, my final goal is actually to put the Age into some aging bucket. There is one table I have with the setu…

[axaeffect]

Hi Brian,
Appreciate it.
Sorry, doesn’t mean I’m too “pushy” though, just curious. If that is the case, by all means, no rush.

Many thanks in advance.

[BrianJ]

@axaeffect,

No worries at all. There are a lot of general concepts bundled up in your questions, so rather than just providing a fix to your measures, I’m pulling together a list of videos and some additional information that will help you understand the key concepts of evaluation/filter/row context, measure branching, etc. which should help you avoid similar problems with future measures.

• Brian