Summarise DAX 06-03-2020 09:11 PM Hi All I would like to count the number of unique projects I have with revenue and was wondering if I should use the summarise function? I was considering using DistinctCount but I believe it's done on a row-by-row basis which should give an...
Summarise DAX 06-03-2020 09:11 PM Hi All I would like to count the number of unique projects I have with revenue and was wondering if I should use the summarise function? I was considering using DistinctCount but I believe it's done on a row-by-row basis which should give an...
I get a feeling that the solution lies somewehere around creatinga column/measure using the DAX function CALCULATE, but I have tried a couple of suggested fixes to similar issues and can't for the life of me get this to work. Any help much appreciated! Thanks. Labels: Help ...
GROUP BY cust_id) AS tGROUP BY t.internalcount I could put this in a SQL view and import in to Power BI, but that would prevent a lot of Power BI function working like slicers etc. Any help would be appreciated. Labels: Need Help Message 1 of 8 773 Views 0 Reply ...
GROUP BY cust_id) AS tGROUP BY t.internalcount I could put this in a SQL view and import in to Power BI, but that would prevent a lot of Power BI function working like slicers etc. Any help would be appreciated. Labels: Need Help Message 1 of 8 841 Views 0 Reply ...
GROUP BY cust_id) AS tGROUP BY t.internalcount I could put this in a SQL view and import in to Power BI, but that would prevent a lot of Power BI function working like slicers etc. Any help would be appreciated. Labels: Need Help Message 1 of 8 773 Views 0 Reply ...
GROUP BY cust_id) AS tGROUP BY t.internalcount I could put this in a SQL view and import in to Power BI, but that would prevent a lot of Power BI function working like slicers etc. Any help would be appreciated. Labels: Need Help Message 1 of 8 841 Views 0 Reply ...