Groupy by from selected columns

[Ramireddy123]

Hi ,

I have four tables ,i want to do group by four columns from four tables as well as aggregate value from that.

[v-ljerr-msft]

Hi @Ramireddy123,

Could you post your table structures with some sample/mock data and the expected result, so that we can better assist on this issue?

It's better to share a dummy pbix file which can reproduce the issue. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading. 

Regards

[Ramireddy123]

select    DATE_PART('year', a11.claim_date::date) AS YEAR_PART,
    a11.current_claim_status AS current_claim_status,
    a11.current_claim_status AS claims_processing_stage_id,
    a12.claim_status_id AS claim_status_id,
    count(distinct a11.claim_id) AS WJXBFS1
from    public.claims    a11
    join    public.claimsprocessingstages_master    a12
      on     (a11.current_claim_status = a12.claims_processing_stage_id)
where    a12.claim_status_id in ('CLS_001')
group by    DATE_PART('year', a11.claim_date::date),
    a11.current_claim_status,
    a11.current_claim_status,
    a12.claim_status_id

i want same output with DAX