The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello Guys how are you?
Imagine that I have the following table structure:
Product Description / Date (at day level) / Hour (24 in a day) / Volume
Summarized data:
My target is: when the user selects the month of March, for example, I should show the sum of Billed and Invoiced for all days / hours in the selected month (these are ok)
But for reading, I need to split it into 2 measures:
Example:
"Reading Last Month"
"This Month"
Therefore, the final result should be:
Links for the PBI file and Excel Data
I appreciate all the community help here 👊
Solved! Go to Solution.
Hi @leorrn ,
Please refer to my pbix file to see if it helps you.
Create a measure.
Measure =
VAR _1 =
MAXX (
FILTER (
ALL ( Table1 ),
Table1[product_descr] = "Reading"
&& Table1[Year Month] = SELECTEDVALUE ( Table1[Year Month] )
),
Table1[Hour]
)
RETURN
CALCULATE (
MAX ( Table1[Final Volume] ),
FILTER (
ALL ( Table1 ),
Table1[Year Month] = SELECTEDVALUE ( Table1[Year Month] )
&& Table1[product_descr] = "Reading"
&& Table1[Hour] = _1
)
)
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @leorrn ,
Please refer to my pbix file to see if it helps you.
Create a measure.
Measure =
VAR _1 =
MAXX (
FILTER (
ALL ( Table1 ),
Table1[product_descr] = "Reading"
&& Table1[Year Month] = SELECTEDVALUE ( Table1[Year Month] )
),
Table1[Hour]
)
RETURN
CALCULATE (
MAX ( Table1[Final Volume] ),
FILTER (
ALL ( Table1 ),
Table1[Year Month] = SELECTEDVALUE ( Table1[Year Month] )
&& Table1[product_descr] = "Reading"
&& Table1[Hour] = _1
)
)
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.