Forum Discussion

IshaDahra's avatar
IshaDahra
Regular Visitor
4 months ago
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
Need Help
  • grazitti_sapna's avatar
    grazitti_sapna
    4 months ago

    Hi IshaDahra,

     

    Use below DAX

     

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

grazitti_sapna's avatar
grazitti_sapna
Super User
4 months ago

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's avatar
    IshaDahra
    Regular Visitor
    4 months ago

    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's avatar
      grazitti_sapna
      Super User
      4 months ago

      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's avatar
        IshaDahra
        Regular Visitor
        4 months ago

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