Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Wendeley-North
Resolver I
Resolver I

Return minimum/maximum of all groups across date range

‎05-28-2021 03:42 AM

Hi, this builds upon an earlier thread that I created here, hence the familiar looking title. 

Last I left off, we had solved the issue of pulling individual historical minimums and maximums based on groups, i.e.:

  1. For a particular group provided by row context, find the last two months worth of data.
  2. For each date within the last two months, dateSum = SUM ( [Value] ).
  3. Return MIN ( dateSum ) for group.

Now, I would like to get the minimum for all groups, i.e.:

  1. Find last two months worth of data.
  2. For each date within the last two groups, dateSum = SUM ( [Value] ) for all groups
  3. Return MIN ( dateSum ) across all the groups, i.e. only 1 value
    • Update 1 June 21 : This needs to work at all levels of drilldown, from [Group] to [Sub_Sub_Sub_Group]. Please refer to Message 2 to see my failed attempt at using ISINSCOPE().

I guess providing illustrations may be easier (Sample data and used measures provided after image):

Wendeley-North_0-1622198097112.png

According to the picture above, the new measure will return the minimum of (-0.06%, -0.05%) = -0.06%, i.e. the column formed by the measure will return only one value for all groups. I will need this to work with drilldown present for the groups present.

Sample Data

SlicerGroup1DateSlicerGroup2IDValueGroupSub_GroupSub_Sub_GroupSub_Sub_Sub_Group
SG1_131-Mar-21SG2_1ID_1-0.07000%Group_1G1_SG1G1_SG1_SSG1G1_SG1_SSG1_SSSG1
SG1_131-Mar-21SG2_1ID_2-0.08000%Group_1G1_SG1G1_SG1_SSG1G1_SG1_SSG1_SSSG2
SG1_131-Mar-21SG2_1ID_30.05000%Group_1G1_SG2G1_SG2_SSG1G1_SG2_SSG1_SSSG1
SG1_130-Apr-21SG2_1ID_30.06000%Group_1G1_SG2G1_SG2_SSG1G1_SG2_SSG1_SSSG1
SG1_130-Apr-21SG2_1ID_1-0.01000%Group_1G1_SG1G1_SG1_SSG1G1_SG1_SSG1_SSSG1
SG1_130-Apr-21SG2_1ID_2-0.04000%Group_1G1_SG1G1_SG1_SSG1G1_SG1_SSG1_SSSG2
SG1_231-Mar-21SG2_1ID_4-0.01000%Group_2G2_SG1G2_SG1_SSG1G2_SG1_SSG1_SSSG1
SG1_104-May-21SG2_1ID_2-0.09000%Group_1G1_SG1G1_SG1_SSG1G1_SG1_SSG1_SSSG2
SG1_103-May-21SG2_1ID_2-0.04000%Group_1G1_SG1G1_SG1_SSG1G1_SG1_SSG1_SSSG2
SG1_104-May-21SG2_1ID_10.06000%Group_1G1_SG1G1_SG1_SSG1G1_SG1_SSG1_SSSG1
SG1_103-May-21SG2_1ID_1-0.05000%Group_1G1_SG1G1_SG1_SSG1G1_SG1_SSG1_SSSG1
SG1_104-May-21SG2_1ID_30.01000%Group_1G1_SG2G1_SG2_SSG1G1_SG2_SSG1_SSSG1
SG1_103-May-21SG2_1ID_3-0.06000%Group_1G1_SG2G1_SG2_SSG1G1_SG2_SSG1_SSSG1
SG1_230-Apr-21SG2_1ID_4-0.05000%Group_2G2_SG1G2_SG1_SSG1G2_SG1_SSG1_SSSG1
SG1_231-Mar-21SG2_1ID_1-0.02000%Group_1G1_SG1G1_SG1_SSG1G1_SG1_SSG1_SSSG1
SG1_231-Mar-21SG2_1ID_30.03000%Group_1G1_SG2G1_SG2_SSG1G1_SG2_SSG1_SSSG1
SG1_231-Mar-21SG2_1ID_20.03000%Group_1G1_SG1G1_SG1_SSG1G1_SG1_SSG1_SSSG2
SG1_230-Apr-21SG2_1ID_3-0.03000%Group_1G1_SG2G1_SG2_SSG1G1_SG2_SSG1_SSSG1
SG1_230-Apr-21SG2_1ID_1-0.04000%Group_1G1_SG1G1_SG1_SSG1G1_SG1_SSG1_SSSG1
SG1_230-Apr-21SG2_1ID_20.01000%Group_1G1_SG1G1_SG1_SSG1G1_SG1_SSG1_SSSG2
SG1_203-May-21SG2_1ID_20.04000%Group_1G1_SG1G1_SG1_SSG1G1_SG1_SSG1_SSSG2
SG1_204-May-21SG2_1ID_20.00000%Group_1G1_SG1G1_SG1_SSG1G1_SG1_SSG1_SSSG2
SG1_204-May-21SG2_1ID_10.00000%Group_1G1_SG1G1_SG1_SSG1G1_SG1_SSG1_SSSG1
SG1_203-May-21SG2_1ID_10.04000%Group_1G1_SG1G1_SG1_SSG1G1_SG1_SSG1_SSSG1
SG1_204-May-21SG2_1ID_30.05000%Group_1G1_SG2G1_SG2_SSG1G1_SG2_SSG1_SSSG1
SG1_203-May-21SG2_1ID_30.04000%Group_1G1_SG2G1_SG2_SSG1G1_SG2_SSG1_SSSG1
SG1_204-May-21SG2_1ID_40.03000%Group_2G2_SG1G2_SG1_SSG1G2_SG1_SSG1_SSSG1
SG1_203-May-21SG2_1ID_4-0.05000%Group_2G2_SG1G2_SG1_SSG1G2_SG1_SSG1_SSSG1

Measures Shown

 

 

 

 

 

2m_min_vera = 
VAR endDate = LASTDATE(Table2[Date]) -- Determined by slicer
VAR startDate = DATE( YEAR(endDate), MONTH(endDate) -2, DAY(endDate) ) -- 1-year lookback
VAR slicerSelection = VALUES( Table2[SlicerGroup1] ) 
VAR filteredTable = 
    FILTER (
        ALLEXCEPT( Table2, Table2[Group], Table2[Sub_Group], Table2[Sub_Sub_Group], Table2[Sub_Sub_Sub_Group] ), -- Create a new table, ignoring the Group row contexts
        Table2[SlicerGroup1] IN slicerSelection &&
        Table2[Date] >= startDate &&
        Table2[Date] <= endDate
    )
VAR t1 =
    SUMMARIZE(filteredTable, Table2[Date], "sumQuantity", SUM ( [Value] ))
RETURN
    -- CONCATENATEX( t1, Table2[Group], "," )
    -- CONCATENATEX( t1, FORMAT([sumQuantity], "0.00%"), "," ) 
    FORMAT( MINX ( t1, [sumQuantity]), "0.00%" )

 

 

 

 

 

 Appreciate any assistance, thank you.

Labels:
Message 1 of 11
759 Views
0
10 REPLIES 10
v-yangliu-msft
Community Support
Community Support

‎06-04-2021 01:32 AM

Hi  @Wendeley-North  ,

Here are the steps you can follow：

1. Create measure.

Measure =
var _table=SUMMARIZE(ALL('Table2'),[Date],[Group],"1",[2m_min_vera])
var _min=MINX(_table,[1])
return
_min

2. Result：

v-yangliu-msft_0-1622795164125.png

Is this answer what you need? Works in all levels of drilling.

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

234Return minimummaximum of all groups across date range.pbix
Message 11 of 11
462 Views
0
v-yangliu-msft
Community Support
Community Support

‎06-02-2021 12:59 AM

Hi  @Wendeley-North  ,

The last line of measure[2m_min_vera] has been modified and can be used for comparison.

2m_min_vera =
VAR endDate = LASTDATE(Table2[Date]) -- Determined by slicer
VAR startDate = DATE( YEAR(endDate), MONTH(endDate) -2, DAY(endDate) ) -- 1-year lookback
VAR slicerSelection = VALUES( Table2[SlicerGroup1] )
VAR filteredTable =
    FILTER (
        ALLEXCEPT( Table2, Table2[Group], Table2[Sub_Group], Table2[Sub_Sub_Group], Table2[Sub_Sub_Sub_Group] ), -- Create a new table, ignoring the Group row contexts
        Table2[SlicerGroup1] IN slicerSelection &&
        Table2[Date] >= startDate &&
        Table2[Date] <= endDate
    )
VAR t1 =
    SUMMARIZE(filteredTable, Table2[Date], "sumQuantity", SUM ( [Value] ))
RETURN
    -- CONCATENATEX( t1, Table2[Group], "," )
    -- CONCATENATEX( t1, FORMAT([sumQuantity], "0.00%"), "," )
    //FORMAT( MINX ( t1, [sumQuantity]), "0.00%" )
MINX( t1, [sumQuantity])

You can add multiple fields to allselected().

Measure =
MINX( ALLSELECTED('Table2'[Group],'Table2'[Sub_Group],'Table2'[Sub_Sub_Group],'Table2'[Sub_Sub_Sub_Group]),[2m_min_vera])

v-yangliu-msft_0-1622620544844.png

But after discovering, when'Table2'[Group],'Table2'[Sub_Group],'Table2'[Sub_Sub_Group],'Table2'[Sub_Sub_Sub_Group] exists, the minimum value is -0.05.

v-yangliu-msft_1-1622620544849.png

There is only one Table2'[Group], the minimum value is -0.06.

v-yangliu-msft_2-1622620544851.png

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

234Return minimummaximum of all groups across date range.pbix
Message 7 of 11
504 Views
0
Wendeley-North
Resolver I
Resolver I
In response to v-yangliu-msft

‎06-02-2021 01:34 PM

Hi that's not quite what I am looking for, but thanks for the reply.

In this image where the groups are not drilled down, the measure should return -0.06%. It has to figure out at which level in the drill down it is, and calculate the minimum within the hierarchy respectively.

Wendeley-North_0-1622665942945.png

To provide a further example:

Wendeley-North_1-1622666027928.png

In the event where the visual is fully drilled down (something like the above, but imagine that the only columns are [Sub_Sub_Sub_Group], the measure should return -0.05% for the whole column.

Message 8 of 11
497 Views
0
Wendeley-North
Resolver I
Resolver I
In response to Wendeley-North

‎06-01-2021 08:05 PM

Hi,

I would like to get the minimum for all groups, i.e.:

  1. Find last two months worth of data.
  2. For each date within the last two groups, dateSum = SUM ( [Value] ) for all groups
  3. Return MIN ( dateSum ) across all the groups, i.e. only 1 value
    This needs to work at all levels of drilldown, from [Group] to [Sub_Sub_Sub_Group]. I have working code if it is [Group] only. Please refer to below to see my failed attempt at using ISINSCOPE().

I guess providing illustrations may be easier (Sample data and used measures provided after image):

Wendeley-North_0-1622198097112.png

According to the picture above, the new measure will return the minimum of (-0.06%, -0.05%) = -0.06%, i.e. the column formed by the measure will return only one value for all groups. I will need this to work with drilldown present for the groups present.

Sample Data

SlicerGroup1DateSlicerGroup2IDValueGroupSub_GroupSub_Sub_GroupSub_Sub_Sub_Group
SG1_131-Mar-21SG2_1ID_1-0.07000%Group_1G1_SG1G1_SG1_SSG1G1_SG1_SSG1_SSSG1
SG1_131-Mar-21SG2_1ID_2-0.08000%Group_1G1_SG1G1_SG1_SSG1G1_SG1_SSG1_SSSG2
SG1_131-Mar-21SG2_1ID_30.05000%Group_1G1_SG2G1_SG2_SSG1G1_SG2_SSG1_SSSG1
SG1_130-Apr-21SG2_1ID_30.06000%Group_1G1_SG2G1_SG2_SSG1G1_SG2_SSG1_SSSG1
SG1_130-Apr-21SG2_1ID_1-0.01000%Group_1G1_SG1G1_SG1_SSG1G1_SG1_SSG1_SSSG1
SG1_130-Apr-21SG2_1ID_2-0.04000%Group_1G1_SG1G1_SG1_SSG1G1_SG1_SSG1_SSSG2
SG1_231-Mar-21SG2_1ID_4-0.01000%Group_2G2_SG1G2_SG1_SSG1G2_SG1_SSG1_SSSG1
SG1_104-May-21SG2_1ID_2-0.09000%Group_1G1_SG1G1_SG1_SSG1G1_SG1_SSG1_SSSG2
SG1_103-May-21SG2_1ID_2-0.04000%Group_1G1_SG1G1_SG1_SSG1G1_SG1_SSG1_SSSG2
SG1_104-May-21SG2_1ID_10.06000%Group_1G1_SG1G1_SG1_SSG1G1_SG1_SSG1_SSSG1
SG1_103-May-21SG2_1ID_1-0.05000%Group_1G1_SG1G1_SG1_SSG1G1_SG1_SSG1_SSSG1
SG1_104-May-21SG2_1ID_30.01000%Group_1G1_SG2G1_SG2_SSG1G1_SG2_SSG1_SSSG1
SG1_103-May-21SG2_1ID_3-0.06000%Group_1G1_SG2G1_SG2_SSG1G1_SG2_SSG1_SSSG1
SG1_230-Apr-21SG2_1ID_4-0.05000%Group_2G2_SG1G2_SG1_SSG1G2_SG1_SSG1_SSSG1
SG1_231-Mar-21SG2_1ID_1-0.02000%Group_1G1_SG1G1_SG1_SSG1G1_SG1_SSG1_SSSG1
SG1_231-Mar-21SG2_1ID_30.03000%Group_1G1_SG2G1_SG2_SSG1G1_SG2_SSG1_SSSG1
SG1_231-Mar-21SG2_1ID_20.03000%Group_1G1_SG1G1_SG1_SSG1G1_SG1_SSG1_SSSG2
SG1_230-Apr-21SG2_1ID_3-0.03000%Group_1G1_SG2G1_SG2_SSG1G1_SG2_SSG1_SSSG1
SG1_230-Apr-21SG2_1ID_1-0.04000%Group_1G1_SG1G1_SG1_SSG1G1_SG1_SSG1_SSSG1
SG1_230-Apr-21SG2_1ID_20.01000%Group_1G1_SG1G1_SG1_SSG1G1_SG1_SSG1_SSSG2
SG1_203-May-21SG2_1ID_20.04000%Group_1G1_SG1G1_SG1_SSG1G1_SG1_SSG1_SSSG2
SG1_204-May-21SG2_1ID_20.00000%Group_1G1_SG1G1_SG1_SSG1G1_SG1_SSG1_SSSG2
SG1_204-May-21SG2_1ID_10.00000%Group_1G1_SG1G1_SG1_SSG1G1_SG1_SSG1_SSSG1
SG1_203-May-21SG2_1ID_10.04000%Group_1G1_SG1G1_SG1_SSG1G1_SG1_SSG1_SSSG1
SG1_204-May-21SG2_1ID_30.05000%Group_1G1_SG2G1_SG2_SSG1G1_SG2_SSG1_SSSG1
SG1_203-May-21SG2_1ID_30.04000%Group_1G1_SG2G1_SG2_SSG1G1_SG2_SSG1_SSSG1
SG1_204-May-21SG2_1ID_40.03000%Group_2G2_SG1G2_SG1_SSG1G2_SG1_SSG1_SSSG1
SG1_203-May-21SG2_1ID_4-0.05000%Group_2G2_SG1G2_SG1_SSG1G2_SG1_SSG1_SSSG1

Measures Shown

 

2m_min_vera = 
VAR endDate = LASTDATE(Table2[Date]) -- Determined by slicer
VAR startDate = DATE( YEAR(endDate), MONTH(endDate) -2, DAY(endDate) ) -- 1-year lookback
VAR slicerSelection = VALUES( Table2[SlicerGroup1] ) 
VAR filteredTable = 
    FILTER (
        ALLEXCEPT( Table2, Table2[Group], Table2[Sub_Group], Table2[Sub_Sub_Group], Table2[Sub_Sub_Sub_Group] ), -- Create a new table, ignoring the Group row contexts
        Table2[SlicerGroup1] IN slicerSelection &&
        Table2[Date] >= startDate &&
        Table2[Date] <= endDate
    )
VAR t1 =
    SUMMARIZE(filteredTable, Table2[Date], "sumQuantity", SUM ( [Value] ))
RETURN
    -- CONCATENATEX( t1, Table2[Group], "," )
    -- CONCATENATEX( t1, FORMAT([sumQuantity], "0.00%"), "," ) 
    FORMAT( MINX ( t1, [sumQuantity]), "0.00%" )

 

Working Code for [Group] only

It gives the output I want:

Wendeley-North_0-1622383268069.png

Measure for 2m_min_all_sectors [2m_min is the same as 2m_min_vera above]:

 

2m_min_all_sectors = 
VAR endDate = LASTDATE(Table2[Date]) -- Determined by slicer
VAR startDate = DATE( YEAR(endDate), MONTH(endDate) -2, DAY(endDate) ) -- 2-month lookback
VAR slicerSelection = VALUES( Table2[SlicerGroup1] ) 
VAR filteredTable = 
    FILTER (
        ALL( Table2 ), -- Create a new table, ignoring the Group row contexts
        Table2[SlicerGroup1] IN slicerSelection &&
        Table2[Date] >= startDate &&
        Table2[Date] <= endDate
    )
VAR t1 =
    SUMMARIZE(filteredTable, Table2[Date], Table2[Group], "sumQuantity", SUM ( [Value] ))
RETURN
    -- CONCATENATEX( t1, Table2[Group], "," )
    -- CONCATENATEX( t1, FORMAT([sumQuantity], "0.00%"), "," ) 
    FORMAT( MINX ( t1, [sumQuantity]), "0.00%" )

 

ISINSCOPE() that returns an error:

 

2m_min_all_sectors = 
VAR endDate = LASTDATE(Table2[Date]) -- Determined by slicer
VAR startDate = DATE( YEAR(endDate), MONTH(endDate) -2, DAY(endDate) ) -- 2-month lookback
VAR slicerSelection = VALUES( Table2[SlicerGroup1] ) 
VAR filteredTable = 
    FILTER (
        ALL( Table2 ), -- Create a new table, ignoring the Group row contexts
        Table2[SlicerGroup1] IN slicerSelection &&
        Table2[Date] >= startDate &&
        Table2[Date] <= endDate
    )
VAR t1 =
    SWITCH(
        TRUE(),
        ISINSCOPE( Table2[Group] ), SUMMARIZE(filteredTable, Table2[Date], Table2[Group], "sumQuantity", SUM ( [Value] )), 
        ISINSCOPE( Table2[Sub_Group] ), SUMMARIZE(filteredTable, Table2[Date], Table2[Sub_Group], "sumQuantity", SUM ( [Value] )), 
        ISINSCOPE( Table2[Sub_Sub_Group] ), SUMMARIZE(filteredTable, Table2[Date], Table2[Sub_Sub_Group], "sumQuantity", SUM ( [Value] )), 
        ISINSCOPE( Table2[Sub_Sub_Sub_Group] ), SUMMARIZE(filteredTable, Table2[Date], Table2[Sub_Sub_Sub_Group], "sumQuantity", SUM ( [Value] ))
    )
RETURN
    -- CONCATENATEX( t1, Table2[Group], "," )
    -- CONCATENATEX( t1, FORMAT([sumQuantity], "0.00%"), "," ) 
    FORMAT( MINX ( t1, [sumQuantity]), "0.00%" )

 

 Appreciate any assistance, thank you.

Message 9 of 11
565 Views
0
Wendeley-North
Resolver I
Resolver I
In response to Wendeley-North

‎06-02-2021 01:35 PM

Bump.

Message 10 of 11
489 Views
0
Wendeley-North
Resolver I
Resolver I

‎06-01-2021 10:21 AM

Bump.

Message 6 of 11
517 Views
0
v-yangliu-msft
Community Support
Community Support

‎05-31-2021 06:24 PM

Hi  @Wendeley-North ,

Here are the steps you can follow：

1. Create measure.

Measure =
MINX( ALLSELECTED('Table2'[Group]),[2m_min_vera])

2. Result:

v-yangliu-msft_0-1622510662832.png

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Return minimum maximum of all groups across date range.pbix
Message 4 of 11
548 Views
0
Wendeley-North
Resolver I
Resolver I
In response to v-yangliu-msft

‎05-31-2021 07:24 PM

Thanks for the reply, but this seems to only work on a [Group] level, but I'll need it to work at all levels of drill down, i.e. [Group], [Sub Group], ... [Sub Sub Sub Group]

Message 5 of 11
541 Views
0
Wendeley-North
Resolver I
Resolver I

‎05-31-2021 01:31 AM

Hi, I've figured a partial solution that works on a manually defined category, i.e. Table2[Group] basis. However, given that this measure will have to work on drill-downs, I can't quite seem to get it to work using ISINSCOPE(). 

The current working code that gives the output I want:

Wendeley-North_0-1622383268069.png

Relevant 2 measures used:

 

2m_min = 
VAR endDate = LASTDATE(Table2[Date]) -- Determined by slicer
VAR startDate = DATE( YEAR(endDate), MONTH(endDate) -2, DAY(endDate) ) -- 2-month lookback
VAR slicerSelection = VALUES( Table2[SlicerGroup1] ) 
VAR filteredTable = 
    FILTER (
        ALLEXCEPT( Table2, Table2[Group], Table2[Sub_Group], Table2[Sub_Sub_Group], Table2[Sub_Sub_Sub_Group] ), -- Create a new table, ignoring the Group row contexts
        Table2[SlicerGroup1] IN slicerSelection &&
        Table2[Date] >= startDate &&
        Table2[Date] <= endDate
    )
VAR t1 =
    SUMMARIZE(filteredTable, Table2[Date], "sumQuantity", SUM ( [Value] ))
RETURN
    -- CONCATENATEX( t1, Table2[Group], "," )
    -- CONCATENATEX( t1, FORMAT([sumQuantity], "0.00%"), "," ) 
    FORMAT( MINX ( t1, [sumQuantity]), "0.00%" )
2m_min_all_sectors = 
VAR endDate = LASTDATE(Table2[Date]) -- Determined by slicer
VAR startDate = DATE( YEAR(endDate), MONTH(endDate) -2, DAY(endDate) ) -- 2-month lookback
VAR slicerSelection = VALUES( Table2[SlicerGroup1] ) 
VAR filteredTable = 
    FILTER (
        ALL( Table2 ), -- Create a new table, ignoring the Group row contexts
        Table2[SlicerGroup1] IN slicerSelection &&
        Table2[Date] >= startDate &&
        Table2[Date] <= endDate
    )
VAR t1 =
    SUMMARIZE(filteredTable, Table2[Date], Table2[Group], "sumQuantity", SUM ( [Value] ))
RETURN
    -- CONCATENATEX( t1, Table2[Group], "," )
    -- CONCATENATEX( t1, FORMAT([sumQuantity], "0.00%"), "," ) 
    FORMAT( MINX ( t1, [sumQuantity]), "0.00%" )

 

ISINSCOPE() that returns an error:

 

2m_min_all_sectors = 
VAR endDate = LASTDATE(Table2[Date]) -- Determined by slicer
VAR startDate = DATE( YEAR(endDate), MONTH(endDate) -2, DAY(endDate) ) -- 2-month lookback
VAR slicerSelection = VALUES( Table2[SlicerGroup1] ) 
VAR filteredTable = 
    FILTER (
        ALL( Table2 ), -- Create a new table, ignoring the Group row contexts
        Table2[SlicerGroup1] IN slicerSelection &&
        Table2[Date] >= startDate &&
        Table2[Date] <= endDate
    )
VAR t1 =
    SWITCH(
        TRUE(),
        ISINSCOPE( Table2[Group] ), SUMMARIZE(filteredTable, Table2[Date], Table2[Group], "sumQuantity", SUM ( [Value] )), 
        ISINSCOPE( Table2[Sub_Group] ), SUMMARIZE(filteredTable, Table2[Date], Table2[Sub_Group], "sumQuantity", SUM ( [Value] )), 
        ISINSCOPE( Table2[Sub_Sub_Group] ), SUMMARIZE(filteredTable, Table2[Date], Table2[Sub_Sub_Group], "sumQuantity", SUM ( [Value] )), 
        ISINSCOPE( Table2[Sub_Sub_Sub_Group] ), SUMMARIZE(filteredTable, Table2[Date], Table2[Sub_Sub_Sub_Group], "sumQuantity", SUM ( [Value] ))
    )
RETURN
    -- CONCATENATEX( t1, Table2[Group], "," )
    -- CONCATENATEX( t1, FORMAT([sumQuantity], "0.00%"), "," ) 
    FORMAT( MINX ( t1, [sumQuantity]), "0.00%" )

 

Message 2 of 11
574 Views
0
Wendeley-North
Resolver I
Resolver I
In response to Wendeley-North

‎06-04-2021 01:24 AM

Bump

Message 3 of 11
466 Views
0

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

View All