Forum Discussion

UG14's avatar
UG14
Frequent Visitor
6 years ago

Distinct Count on a Column in Group By

I have to create a table in Power BI from SQL Query- **Select I.CompanyID, I.CompanyName, ID.Service, --Year(I.InvoiceStartDate) as Year, --Month(I.InvoiceStartDate) as Month, SUM(ID.TimeInvoi...
Need Help
Tips and Tricks
V-lianl-msft's avatar
V-lianl-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi UG14 ,

 

Try to create 2 measures:

Measure = CALCULATE(DISTINCTCOUNT(Table1[InvoiceStartDate].MONTH),ALLEXCEPT(Table1,Table1[TimeInvoiced ],Table1[FinalServiceAmount ]))

Measure 2 = SUMX(ALLEXCEPT(Table1,Table1[XX]),[Measure])

 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.