User Profile
jagadeesh3001
Frequent Visitor
Joined 1 year ago
User Widgets
Contributions
Re: New Dax to calculate sum by changing join
Here one more solution i found after multiple tries this don't need any changes in data model/joins (also not needed to use treatas / userelationship) test_dax = IF (SELECTEDVALUE('Dim Product'[Product]) = "carry value adj", BLANK(), CALCULATE( SUM('fact'[amt]), 'dim product ref'[product ref]=SELECTEDVALUE('dim product'[product]), ALL('dim product'[product]) )3KViews1like0CommentsRe: New Dax to calculate sum by changing join
Thanks for your time & dax formula, but this is giving same amt as original amt which is not as expected. Product Product_Ref Amt Test_DAX capacity n/a 10 10 n/a n/a 20 20 carry value adj capacity 30 Blank carry value adj colletral swaps 40 Blank netting capacity 60 60 colletral swaps n/a 50 503.1KViews0likes0CommentsRe: New Dax to calculate sum by changing join
here is current report based on joins explained abv i need below "test_dax" if i filter original data for Product = "carry value adj" subset of product_ref, amt looks like below (which is what looked up to populate in new test_dax) i would like to know how this can be done in DAX3.4KViews0likes0CommentsRe: New Dax to calculate sum by changing join
This is current report based on all joins explained (Fact to Product based on Product_iD; to Product_ref based on product_ref) Product Product_Ref Amt capacity n/a 10 n/a n/a 20 carry value adj capacity 30 carry value adj colletral swaps 40 netting capacity 60 colletral swaps n/a 50 Need test_dax as shown below Product Product_Ref Amt Test_DAX capacity n/a 10 30 n/a n/a 20 Blank carry value adj capacity 30 Blank carry value adj colletral swaps 40 Blank netting capacity 60 Blank colletral swaps n/a 50 403.4KViews0likes5CommentsNew Dax to calculate sum by changing join
Hi All, I’m new to Dax, please help me get below achieved fact (sample data) product_id, product_ref, amt 1,n/a,10 2,n/a,20 3,capacity,30 3,colletral swaps,40 4,capacity,60 6,n/a,50 Dim product (sample data) product_id, product 1,capacity 2,n/a 3,carry value adj 4,netting 5,tba sales 6,colletral swaps Dim product ref (sampel data) product_ref N/a capacity colletral swaps Using abv 3 tables Pbi model Fact (product_id) joined to dim product (product_id) Fact (product_ref) joined to dim_product_ref (product_ref) With these joins if I create a simple report with amt Product, product_ref, amt capacity,n/a,10 n/a,n/a,20 carry value adj,capacity,30 carry value adj,colletral swaps,40 netting,capacity,60 colletral swaps,n/a,50 Now I need a new Dax measure (test_dax) to get below out put Product, product_ref, amt, test_dax capacity,n/a,10,30 n/a,n/a,20,blank carry value adj,capacity,30,blank carry value adj,colletral swaps,40,blank netting,capacity,60,blank colletral swaps,n/a,50,40 As you see new Dax measure is calculated based off of summarized/sub set of (prod_ref, amt - by applying filter on prod = carry value adj) then left join prod_ref with product to get amt I have tried using treatas but didn’t get me desired output Thanks in advanceSolved3.5KViews1like16Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.