Forum Discussion
Post ProdigyNeed to use Average & Divide function
@harirao, what's the problem. Not very clear.
If the denominator is not a measure. Then you need the aggregation there to
Depending on the need it can be count, distinctcount, sum Average Atc
DIVIDE(AVERAGE(tbl_dep3_big_deal_perf_data_final_main[MAX_Cal_MWT]),Count(tbl_dep3_big_deal_perf_data_final_main[sapsoliID]),0)
@harirao , you can change the data type to decimal by adding some decimal places and checking.
Can you share sample data and sample output in table format? Or a sample of pbix after deleting sensitive data.
Super User@harirao, what's the problem. Not very clear.
If the denominator is not a measure. Then you need the aggregation there to
Depending on the need it can be count, distinctcount, sum Average Atc
DIVIDE(AVERAGE(tbl_dep3_big_deal_perf_data_final_main[MAX_Cal_MWT]),Count(tbl_dep3_big_deal_perf_data_final_main[sapsoliID]),0)
Post ProdigyHello amitchandak ,
Thanks for your quick response, I want to create a single dax using two columns from source Average & divide function i.e (Avg of MAX_Cal_MWT by SapsoliShipID)
Getting all values as Zero:
Thank you
- amitchandak
@harirao , you can change the data type to decimal by adding some decimal places and checking.
Can you share sample data and sample output in table format? Or a sample of pbix after deleting sensitive data.