Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi all,
I have 2 tables in a multidimension cube (that is why here I can use only "Create Measure" and cannot use "Create Column" for the calcualtion)
1. Table 1: where have information of KST Original, PNr, Sollz, Istz, Effzeit. The filter for this table that value should be filtered when KSTWech is "Ja".
2. Table 2: where have information of KST actual, PNr, SollGesamt, HauptKST. Here should not be affected by Filter KSTWech.
I would like to have merge values that taking information of SollGesamt & HauptKST from Table 2 into Table 1
I created measure
SollGesamt = CALCULATE([Sollz], ALL(FACT_ProductivityList[KSTWech]))
I do not know how to adjust my measure to let it display HauptKST value from table 2 (also from some selected KST actual as avove) rightly with condition column of KST Ori of table 1
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
11 | |
9 | |
8 | |
8 | |
8 |
User | Count |
---|---|
13 | |
12 | |
11 | |
10 | |
9 |