Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi guys,
I need to calculate values like the following:
Plan | Fact | New measure | |
15 | |||
15 | |||
15 | |||
15 | |||
15 | 15 | 15 | |
15 | |||
15 | |||
15 | |||
15 | |||
15 | |||
15 | |||
15 | |||
Total | 180 | 15 | 15 |
I almost done this with Matrix plan = if(not(ISBLANK([Fact]));'Local Measure'[Plan];blank()) but it shows me wrong value in totals (still 180 instead of 15).
Plan and Fact values from different tables. Both tables - live and already calculated data.
Is that possbile to do?
HI @idontexist
Try adding if hasonevalue before your MEASURE
If(hasoneValue(LocalMEasure[Plan]), YourMEASURE)
is the Plan Column aggregated in some way?
It's plan for store for all days in month. Table "plan" contains 3 columns: date, store code and value. Value already calculated before downloading in live cube, so it's just number.
Hi @idontexist,
Can you share the pbix file please? The relationship between two tables could affect the result.
Best Regards,
Dale
Hi, @v-jiascu-msft
i can do that, but you will not be able to see anything, as it's connected to live cube. And i don't have rights to grant you access.
Hi @idontexist,
As far as I know, we can't create a measure in the mode live to SSAS cube. Did I miss something?
Best Regards,
Dale
Hi @idontexist,
Hasonevalue could work. Please see the example below. What's your report like? Can you share a snapshot?
Measure 6 = IF ( HASONEVALUE ( 'DimProduct'[ClassName] ), SUM ( FactSales[SalesQuantity] ), 0 )
Best Regard,
Dale
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
99 | |
93 | |
88 | |
70 |
User | Count |
---|---|
166 | |
133 | |
129 | |
102 | |
98 |