Serial No. in visualisation

[IshaDahra]

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

[v-sgandrathi]

Hi @IshaDahra,

I wanted to follow up on our previous suggestions regarding the issue. We would love to hear back from you to ensure we can assist you further.

Thank you.

[v-sgandrathi]

Hi @IshaDahra,

Thank you @Praful_Potphode  and @grazitti_sapna for your response to the query.

we haven't heard back from you regarding our last response and wanted to check if your issue has been resolved.

Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!

[Praful_Potphode]

Hi @IshaDahra 

You can create visual calculation(Select Your Visual->Home->New Visual Calculation) like below in your visual:

Order by can be changed based on your requirement.

RowNumber = FORMAT(
    ROWNUMBER(
    ROWS,
    ORDERBY([reporting year],ASC)
    )
    ,"0"
)

Please give kudos or mark it as solution once confirmed.

Thanks and Regards,

Praful

LinkedIn

[grazitti_sapna]

Hi @IshaDahra,

You can use below DAX

Serial No =
RANKX(
ALLSELECTED(
'Table1'[Column1],
'Table2'[Column2],
'Table3'[Column3]
),
CALCULATE(1),
,
ASC,
DENSE
)

If you have one key column in table you can use it like below

Serial No =
RANKX(
ALLSELECTED(FactTable[UniqueID]),
MAX(FactTable[UniqueID]),
,
ASC
)

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!

[IshaDahra]

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

[grazitti_sapna]

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
)

[IshaDahra]

Date and UniqueID is not from the same table.,
So we're getting this:
Argument '2' in CALCULATE function is required.

[grazitti_sapna]

Please share the DAX you are using

[IshaDahra]

S.No =

RANKX( SUMMARIZE( ALLSELECTED('FACT_STORY'), 'FACT_STORY'[Number], FACT_STORY[Updated]), CALCULATE(MIN(FACT_STORY[Updated]), ,ASC, DENSE )

 )

[grazitti_sapna · Accepted solution]

Hi @IshaDahra,

Use below DAX

S.No =
RANKX(
SUMMARIZE(
ALLSELECTED('FACT_STORY'),
'FACT_STORY'[Number],
"MinUpdated", MIN('FACT_STORY'[Updated])
),
[MinUpdated],
,
ASC,
DENSE
)