Forum Discussion

Aadi's avatar
Aadi
New Member
9 years ago

Count and then running Sum functionality in Power BI

Hi Experts,   Need your help here :   I have two coloumns "Fiscal Month" and "Ord ID" . My requirement is to take the "count of Org Id" and then Take the running sum of that "count of Org Id".  ...
Need Help
Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

 

Aadi

 

 

Hi, use this DAX Measure

 

RunningCount =
SUMX (
    FILTER ( ALL ( Table1 ), Table1[Fiscal Month] <= MAX ( Table1[Fiscal Month] ) ),
    DISTINCTCOUNT ( Table1[Org Id] )
)

 

Regards

 

Victor

Lima - Peru

Aadi's avatar
Aadi
New Member
9 years ago

Thanks Victor for your reply.

 

This is working with Excel datasource but same when i connect to HADOOP iam not getting the desired result. It just gives me the DistinctCount ie Value 1 for all months. :mansad: