Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hello,
Please help with this issue. How to created helper measure for this selection
I want to use only ID slicer and get this result for two tables:
1.Table 1 shows detailed information about ID;
2.Table 2 shows all the ID of the shop, where belongs selected ID (including selected ID).
Please check the picture attached.
Solved! Go to Solution.
Hi @PrieleBI
This design does not align with best practices for relationships. Typically, relationships should flow from Dim to Fact tables in a one-to-many structure. However, in your model, the relationships flow from Fact to Dim. Moreover, your sales table will likely be on the many side of relationships, so the flow should be toward it in a one-to-many structure, not the other way around. Additionally, the Shop Plan table is another fact table. To properly link the two fact tables, you'll need to create additional dimension tables, such as Shop and Product, to act as bridges.
Once the model is properly setup, you should be able to create working measures with a simple logic.
Sales Qty all ID =
CALCULATE ( SUM ( Sales[SalesQuant] ), REMOVEFILTERS ( Sales[ID] ) )
Plan Execution =
DIVIDE ( [Sales Qty all ID], SUM ( ShopPlan[Shop Plan] ) )
Please see the attached pbix.
Proud to be a Super User!
Hi @PrieleBI
This design does not align with best practices for relationships. Typically, relationships should flow from Dim to Fact tables in a one-to-many structure. However, in your model, the relationships flow from Fact to Dim. Moreover, your sales table will likely be on the many side of relationships, so the flow should be toward it in a one-to-many structure, not the other way around. Additionally, the Shop Plan table is another fact table. To properly link the two fact tables, you'll need to create additional dimension tables, such as Shop and Product, to act as bridges.
Once the model is properly setup, you should be able to create working measures with a simple logic.
Sales Qty all ID =
CALCULATE ( SUM ( Sales[SalesQuant] ), REMOVEFILTERS ( Sales[ID] ) )
Plan Execution =
DIVIDE ( [Sales Qty all ID], SUM ( ShopPlan[Shop Plan] ) )
Please see the attached pbix.
Proud to be a Super User!
Thanks @danextian ,
One thing is missing till 100 proc. solution, could you helo with it.
Is it possible, that second table would show only Shop X ? (because the selected ID is from Shop X, so only this Shop is needed in table data).
Logic: User choose ID -> Accoding to selection :
>> Table 1 shows detailed ID information
>> Tabel 2 shows the Shop information ( exactly that shop, where ID is from) and the shop data is from the same week as ID week.
You can just visually filter it by Sales Qty all ID <> blank.
Proud to be a Super User!
Hi,
Here's my take
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
75 | |
63 | |
52 | |
47 |
User | Count |
---|---|
215 | |
85 | |
61 | |
61 | |
60 |