March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hello fellow members,
Need help with a Measure to not display the maximum cohort period on each row per MonthYear on the following visual.
Example
MonthYear May-19 should stop at period 13
MonthYear June-19 should stop at period 13
MonthYear Jul-19 should stop at period 12 etc...
Therefore the measure should be Max period minus 1. Hope I'm clear enough. Thanks in advance.
Solved! Go to Solution.
@BICrazy - I am thinking something like:
Measure
VAR __Calc = <some calc>
VAR __Period = MAX('Table'[Period] // whatever is in your Columns
VAR __Num = COUNTROWS(ALL('Table'[Period]),[Period]>__Period
RETURN
IF(ISBLANK(__Num),BLANK(),__Calc)
@BICrazy , in your case these measure on top of you measure should work
if([Measure]=0, blank(), [measure]) or
sumx(values(Table[Monthyear]),if([Measure]=0, blank(), [measure]))
@BICrazy
Include our measure within an IF condition like:
Measure New =
IF(
SELECTEDVALUE(Table[Day])> 10 ,
BLANK() ,
[Your% Measure]
)
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@BICrazy
Include our measure within an IF condition like:
Measure New =
IF(
SELECTEDVALUE(Table[Day])> 10 ,
BLANK() ,
[Your% Measure]
)
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Fowmy , @amitchandak , @Greg_Deckler
All of the measures you guys proposed worked in my case. Thanks a mill for your help.
@BICrazy Always more than 1 way to do things in DAX!!
@BICrazy , in your case these measure on top of you measure should work
if([Measure]=0, blank(), [measure]) or
sumx(values(Table[Monthyear]),if([Measure]=0, blank(), [measure]))
@BICrazy - I am thinking something like:
Measure
VAR __Calc = <some calc>
VAR __Period = MAX('Table'[Period] // whatever is in your Columns
VAR __Num = COUNTROWS(ALL('Table'[Period]),[Period]>__Period
RETURN
IF(ISBLANK(__Num),BLANK(),__Calc)
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
27 | |
17 | |
16 | |
12 | |
11 |
User | Count |
---|---|
38 | |
29 | |
24 | |
20 | |
16 |