Forum Discussion

Arun_S's avatar
Arun_S
Regular Visitor
8 years ago
Solved

Roll up Calculations

  Hi - I am new to Power BI. Assuming the above is my dataset, I can now create a new column for ItemCost (Qty * Rate). How can I create a column or measure for InvoiceCost. I am looking at wa...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Arun_S,

     

    Create a measure using DAX below.



    count = 
VAR tab= SUMMARIZE(Table,Table[Invoice_Num],"cost",SUMX(Table,Table[Qty]*Table[Rate]))

return
CALCULATE(COUNTROWS(FILTER(tab,[cost]<10)))




    Regards,
    Lydia

Arun_S's avatar
Arun_S
Regular Visitor
8 years ago

Hi - I have no problems displaying in a tabular form (Invoice & InvoiceCost). What i am looking for is to display the count (just the count of invoices) on a Card. so, for the above example, i would like to have a Card which says the number 2

 

appreciate your help and time

Arun

 

Arun_S's avatar
Arun_S
Regular Visitor
8 years ago

Experts - any help pls ? thanks.

  • mitsu's avatar
    mitsu
    Resolver IV
    8 years ago

    USe countx Something like this should work 

     

     

    COUNTX(FILTER('Table',[Amount]<10),[Invoice])

     

     

    Please do check and let us know .

     

     

    Thanks,

    Mitsu