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.
Good
When I use the COUNT function, the result that appears to me is:
However, if we go to the table, we find that:
So with the rest of the elements. The elements of that column, I have them in the following table "DimStRet"
Solved! Go to Solution.
Hi @Anonymous ,
To my knowledge, the filters in "Data view" won't affect the results in "Report view". It's used to check the result of measures.
Best regards
Icey
If this post helps, then consider Accepting it as the solution to help other members find it faster.
Hi @Anonymous ,
To my knowledge, the filters in "Data view" won't affect the results in "Report view". It's used to check the result of measures.
Best regards
Icey
If this post helps, then consider Accepting it as the solution to help other members find it faster.
@Anonymous
Can you please post the measure?
Proud to be a Super User!
Paul on Linkedin.
Estatus Retención = IF(FactVentas[Diferencía de días retención]>0 && FactVentas[Estado Retención] = "NO", "Reclamar",
IF(FactVentas[Diferencía de días retención] > - 10 && FactVentas[Estado Retención] = "NO" && FactVentas[Cobro Parcial] = "No tiene", "Por vencer",
IF(FactVentas[Estado Retención]= "Sin retencion", "No retiene",
IF(FactVentas[Estado Retención] = "Parcial" && FactVentas[Diferencía de días retención] > 0 && FactVentas[Cobro Parcial] = "Si", "Reclamar",
IF(FactVentas[Diferencía de días retención]<0 && FactVentas[Estado Retención] = "NO" && FactVentas[Cobro Parcial] = "No tiene", "Esperar",
IF(FactVentas[Estado Retención]= "Si","Cobrado",
IF(FactVentas[Estado Retención] = "No" && FactVentas[Diferencía de días retención] > -30 && FactVentas[Cobro Parcial] = "Si", "Por vencer",
if(FactVentas[Diferencía de días retención] > -275 && FactVentas[Cobro Parcial] = "No" && FactVentas[Estado Retención] = "No", "Retención L",
"Esperar"))))))))
@Anonymous
I meant the COUNT measure. The measure you posted returns a string, does it not?
Proud to be a Super User!
Paul on Linkedin.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |