Forum Discussion
Solved
Serial No. in visualisation
Hi, I have inserted a table in visualization in which columns are taken from different tables. I want a column in which serial no. comes
Hi IshaDahra,
Use below DAX
S.No =
RANKX(
SUMMARIZE(
ALLSELECTED('FACT_STORY'),
'FACT_STORY'[Number],
"MinUpdated", MIN('FACT_STORY'[Updated])
),
[MinUpdated],
,
ASC,
DENSE
)
Hi,
The first dax is giving error:
All column arguments of the ALL/ALLNOBLANKROW/ALLSELECTED/REMOVEFILTERS function must be from the same table.
And, second is giving only 1
Hi IshaDahra,
Got the issue, All selected can only use single table and 1 is due to the MAX function.
Try below DAX
Serial No =
RANKX(
SUMMARIZE(
ALLSELECTED('FactTable'),
'FactTable'[WorkerID],
'FactTable'[Date]
),
CALCULATE(MIN('FactTable'[Date])),
,
ASC,
DENSE
)
Date and UniqueID is not from the same table.,
So we're getting this:
Argument '2' in CALCULATE function is required.Please share the DAX you are using
- S.No =RANKX( SUMMARIZE( ALLSELECTED('FACT_STORY'), 'FACT_STORY'[Number], FACT_STORY[Updated]), CALCULATE(MIN(FACT_STORY[Updated]), ,ASC, DENSE ))