Forum Discussion

reddeppag's avatar
reddeppag
Frequent Visitor
8 years ago
Solved

DAX - Grouping on multiple columns and the count

I have a DB table which has data as the following: Please help on the below task asap. Input Data     Output Data  Area Element     Result     H.0100 H.0100.01.01.01      Area...
  • reddeppag's avatar
    reddeppag
    8 years ago
    I got the solution on the below question NumberOfOpenPO's = CALCULATE ( COUNTROWS ( VendorData), ALLEXCEPT ( VendorData,VendorData[Delivery Area], VendorData[WBS Element],VendorData[Agebucket]) ) Happy Coding!!!!!!!!!!!
reddeppag's avatar
reddeppag
Frequent Visitor
8 years ago
I got the solution on the below question NumberOfOpenPO's = CALCULATE ( COUNTROWS ( VendorData), ALLEXCEPT ( VendorData,VendorData[Delivery Area], VendorData[WBS Element],VendorData[Agebucket]) ) Happy Coding!!!!!!!!!!!